Cannot access mysql from terminal with MAMP

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

Most Liked Posts
  1. NsK, Sep 27, 2009

    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
     
    share
    + Quote Reply
  2. NsK, Sep 27, 2009

    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?
     
    share
    + Quote Reply
  3. savar, Sep 27, 2009

    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
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page