PDA

View Full Version : Cannot access mysql from terminal with MAMP




NsK
Sep 27, 2009, 01:55 PM
I have installed the latest version of MAMP to learn php and mysql web development. I am trying to access to the databases from terminal but I am not able to do so. Can anyone tell me how to access to mysql from terminal with MAMP.

thanks



NsK
Sep 27, 2009, 01:59 PM
Okay I just found teh solution

-Launch MAMP
-Launch Terminal
-In Terminal: /Applications/MAMP/Library/bin/mysql -uroot -p
-Entered password


now I can connect to it...but is there a way to connect to the database remotely from another computer with MAMP?

savar
Sep 27, 2009, 06:11 PM
Okay I just found teh solution

-Launch MAMP
-Launch Terminal
-In Terminal: /Applications/MAMP/Library/bin/mysql -uroot -p
-Entered password


now I can connect to it...but is there a way to connect to the database remotely from another computer with MAMP?

mysql -h <your IP address> -u root -p

Also, try 'man mysql' to learn about how to use the command line client.