Cannot access mysql from terminal with MAMP

[NsK]

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]

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]

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.