How to install MySQL on Leopard, Mac OS X 10.5?

Question

I followed this tutorial to the very end, then found out it didn't work right. I think I have everything installed but when I type

mysql -uroot

I only get

-bash: mysql: command not found

Note: I did not skip the "Setting the Path" step. Upon running this command for the first time:

mate ~/.bash_login

This brought up an empty file. So I added this line:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

I saved the file, closed TextMate, executed the following command:

. ~/.bash_login

...and continued with the tutorial. Based on your suggestions, I thought maybe the file didn't actually get saved. So I ran the following command to bring up the file again:

mate ~/.bash_login

...yet the contents of the file were as they should be.

Any suggestions?

Answer 1

You probably don't have the mysql binaries in your path.

The link you posted has a section on setting the path, titled "Setting the Path Do not skip this step! Most everything else will fail if you do."

EDIT: As debugging steps, try:

• First launching a new terminal window. Does it run now?
• Typing "echo $PATH" at the prompt. Does the path show up correctly as you've typed it in bash_profile?
• Running it the long way: /usr/local/mysql/bin/mysql -u root Does the application run?

Answer 2

Did you follow the step that says

Setting the Path

Do not skip this step! Most everything else will fail if you do.

Did you close your terminal window and re-open it afterwards?

Update: What does "which mysql" say? Does "ls /usr/local/mysql/bin" say?

Answer 3

Another option would be to use MAMP.

It has Apache, PHP and MySQL packaged with no further setup necessary.

Answer 4

MySQL is usually put in /usr/local/mysql/bin/

You need to add this to your PATH, you can do this by adding the follwoing lines to your .bash_profile

PATH=$PATH:/usr/local/mysql/bin/
export PATH

The .bash_profile file is located in the root of your username directory.

Make sure you restart your Terminal for the setting to take affect.

Answer 5

And if you're not a command-line person, I highly recommend you also install the MySQL Preference Pane to start/stop the server and install Sequel Pro to create databases and run queries.

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip

http://www.sequelpro.com/

Answer 6

Two things:

• Try editing ~/.profile (rather than ~/.bash_profile or ~/.bash_login).
• You may find it easier to use the native Mac style .dmg installer directly from Sun.

One nice thing about the dmg installer is that it automagically sets up symlinks to /usr/local/mysql (which means less - or no - fiddling with your $PATH).