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;.

Using MySQL command line with MAMP