Mac OS X 10.6 snow leopard uses the bash shell by default. If you install MySQL from the disk image (dmg) from http://dev.mysql.com/downloads/, you can make it easy to access the mysql binary from the command line by adding it to your bash path.
Here’s how:
Open terminal, and type:
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile
This adds the default location of the MySQL binary to your shell environment.
Then, you need to force the system to reload your .bash_profile file. Again, from terminal, enter:
. ~/.bash_profile
You can check your environment variables by typing in terminal:
env
Now, to access MySQL from the command line, you only need enter:
mysql
You sir are the greatest man ever to have graced the earth with your presence. To simple commands solved a problem 2 hours of data reference guides couldn’t.
Thanks !
That’s it?! Thank you!
Thank you very much!
Thanks a lot! Nice and simple.
effusive praise and thanks: you have saved me a lot of head scratching and hair pulling.
I receive an error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
Perhaps your MySQL installation and PHP are looking in different places for the socket file. From command line (terminal), execute mysqladmin variables to view the location of the socket. See http://support.apple.com/kb/TS1999?viewlocale=en_US&locale=en_US for some possibly related issues.
Excellent stuff.. thank you 🙂