DEV Community

Arbaoui Mehdi
Arbaoui Mehdi

Posted on

How to access the MySQL CLI With MAMP

First, you’ve to start MAMP or MAMP PRO, and you open your terminal and type:

/Applications/MAMP/Library/bin/mysql -uroot -p
Enter fullscreen mode Exit fullscreen mode

Enter the password, by default the password, is root:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 254
Server version: 5.6.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
Enter fullscreen mode Exit fullscreen mode

If you want to use the command mysql by default without typing the entire command line you can edit one of these dot files ~./bashrc if you’re using bash or ~/.zshrc in case of using zsh and add this alias:

alias mysql=/Applications/MAMP/Library/bin/mysql
Enter fullscreen mode Exit fullscreen mode

After editing the file using Vim or Nano editor save the dot file, and run the source to validate the modification.

If you're using use zsh:

source ~/.zshrc
Enter fullscreen mode Exit fullscreen mode

If you're using bash:

source ~/.bashrc
Enter fullscreen mode Exit fullscreen mode

Now you can run the command mysql from the terminal and enter the username and the password:

mysql -uroot -proot
Enter fullscreen mode Exit fullscreen mode

Discussion (2)

Collapse
senhleeiclee profile image
senh lee

It appears your information is valid for MAMP only, not MAMP PRO. Would you like to verify that ! I still couldn't get to MAMP PRO MySql.

Collapse
devzom profile image
Jacob

That's true, MAMP PRO is stored in '~/' folder as MAMP folder
so should open it by

cd ~/MAMP/bin/ && mysql -uroot -p
Enter fullscreen mode Exit fullscreen mode