Friday, August 28, 2009

Using MySQL command line with MAMP

To use the MySQL command line with MAMP or MAMP PRO, perform the following steps:
  1. Start MAMP or MAMP PRO
  2. Start the server
  3. Open Terminal (Applications -> Utilities)
    Type in: (one line)
    /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot
Now you can use the MySQL command line. For exmaple to show all your databases with show databases;.

Share/Save/Bookmark