How to access the MySQL CLI With MAMP

Arbaoui Mehdi - Sep 26 '19 - - Dev Community

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
. . . . . . . . . . . . . . . . . . .
Terabox Video Player