Cannot access mysql from terminal with MAMP

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

  1. NsK macrumors member

    Joined:
    Dec 7, 2006
    #1
    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
     
  2. NsK thread starter macrumors member

    Joined:
    Dec 7, 2006
    #2
    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

    savar

    Joined:
    Jun 6, 2003
    Location:
    District of Columbia
    #3
    Code:
    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