Cannot access mysql from terminal with MAMP

Discussion in 'Web Design and Development' started by NsK, Sep 27, 2009.

  1. NsK macrumors member

    Dec 7, 2006
    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.

  2. NsK thread starter macrumors member

    Dec 7, 2006
    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?
  3. savar macrumors 68000


    Jun 6, 2003
    District of Columbia
    mysql -h <your IP address> -u root -p
    Also, try 'man mysql' to learn about how to use the command line client.

Share This Page