Mamp has integrated phpMyAdmin, which can be easily uploaded to a small database, but not easy to operate for a large database. However, we can operate the database through the terminal. The following will record the process of uploading the database using MAMP

1. First create a database name in phpMyAdiminmydb;

2. Open the terminal and enter the following codes:

CD ` / ` Applications/MAMP/Library/bin into the bin folder. / mysql - uroot - p - ACopy the code

3. Please input your password and press Enter. (I have encountered an error prohibiting login here, and found that I have entered the wrong password after inquiry.

4. The following page is displayed

5. Enter the following code in the mysql server to upload the database:

use mydb; SQL (source+ database address to upload)Copy the code