MySQL command line with OS X 10.6.

17 01 2011

After installing MySQL 5.1.54 on Mac OS X 10.6.6 (Snow Leopard) I tried to access the server in the terminal and got:

-bash: mysql: command not found

Bash could not find the path, so I had to add it. I am not that familiar with the internals of the unix terminal anyway, so I found a highly informative thread on superuser.com.

Especially the post of Jim Logan solved the issue:

Take a look at the file /etc/paths, which is used by /usr/libexec/path_helper, which is used by /etc/profile. For MacPorts, use “sudo” to append “/opt/local/bin” to the end of the /etc/paths file and reopen the terminal window.

So I opened the terminal and used nano:
sudo nano /etc/paths

and appended the line
/usr/local/mysql/bin

to the file, saved, exited, restarted the terminal …. and voila, solved.

About these ads

Actions

Information

Date : January 17, 2011
Tags: bash, path, shell, terminal
Categories : BASH, Database

7 responses

28 07 2011: tureeya (06:40:34) :

great! had the same issue and found it really helpful.. thanks…

Reply
24 03 2012: Philip (11:47:17) :

Thanks it works like a charm

Reply
16 05 2012: JK (02:44:13) :

worked for me; thanks dood

Reply
6 11 2012: gabe (15:47:19) :

great help thanks!

Reply
21 12 2012: hk (08:08:28) :

how to exit it and save it

Reply
21 12 2012: rforge (10:59:04) :

If you used nano then Ctrl-O saves and Ctrl-X exits. Might be that on Apple keyboard it is Cmd-O and Cmd-X (Cmd for the “Apple”-key).

Reply
15 02 2013: Jatin (20:00:26) :

Thanks a ton. Very simple solution which I could not get anywhere else or think of.

Reply