I’m still quite new to the use of command line, so if there is any better way of doing it, please don’t hesitate to let me know in the comments.
To connect to your MAMP MySQL database via command line, first navigate to the correct directory within your MAMP installation using the Terminal (or another SSH client). Example:
cd /applications/mamp/Library/bin |
Then run the command to connect to MySQL (the default user and password are both ‘root’).
Example:
mysql -u root -p |
You should now see this:
mysql> |
Update:
Here is a very nice post with some more details:
aschroder.com
And a list of terminal commands and their meaning:
ss64.com/osx/
Update:
To avoid typing the location of MySQL each time you open the terminal, you can set the location by default. Open the ‘bash_profile’ file in the user root:
pico bash_profile |
Add the location of MySQL in a new line:
export PATH=$PATH:/Applications/MAMP/Library/bin/mysql |
Instructions on how to use the Pico editor here: ss64.com/osx/pico.html
Now you should get to MySQL simply by typing mysql into the terminal.



Recent Comments