Re: How to Execute MySQL program in Unix Terminal on OS X?

[Jeff Jones]

You'll need to issue the following command in the terminal:

mysql -u <username> -p

It will then ask you for the username's password and you should be in the monitor.

From there you can issue MySQL/SQL statements.

The -u asks for a username and the -p means to prompt you for the password.

I'm a Mac user who's new to MySQL but I use both PHPMyadmin and the monitor.

Don't forget that the Terminal in OS X has command memory so you can recall cycle through previous commands with the up and down arrow keys. Saves a lot of typing!!!