php - How to run mysql commands from terminal on a MAMP install?

Question

I just installed mamp (xampp) from the mamp.info page and it is working on my mac (both apache, php, phpmyadmin, and mysql). The only problem is when i try to run

mysql -u root -p

Which connects to mamp from the mac os terminal, i get a command error. I have installed and uninstalled mamp and xampp for mac multiple times to no avail.

I am following this tutorial; http://www.raywenderlich.com/2941/how-to-write-a-simple-phpmysql-web-service-for-an-ios-app and i can't get past a certain part because i don't want to use php admin, and i think it'd be cool to use it from the terminal.

My question; how do i configure mamp or xampp for mac to work from the terminal?

Answer 1

Put this at the end of your .bash_profile script (create it if it doesn't already exist):

export PATH=$PATH:/Applications/MAMP/Library/bin