MAMP PRO (macOS) Documentation

Sites > Site > Databases

The Database tab shows which databases are associated with each site. You can assign individual databases or tables to a site. Disabled checkboxes indicate databases and tables that are associated with a site via an extra or automatic WordPress installation. This association cannot be broken.

The mapping of a database to a site is used by the Remote and Cloud features. This mapping tells MAMP PRO which site is associated with which database(s).

Create Database

To create a new database, click the “+” button at the bottom of the databases table. You can only create databases, not individual tables. Please use a database administration tool such as phpMyAdmin. You can access phpMyAdmin via the “Open in” button in the header of the database table.

• Name
  Enter the name of the new database.

• After creating the new database…

  • grant access to User
    If this box is unchecked (default), the new database will be created by and granted privileges to the MySQL “root” user. When you grant access, you have the choice of using an existing user or creating a new user.

    The newly created MySQL user has all privileges only for the newly created database. It has no privileges for any other database.

  • with Password
    If you choose to create a new MySQL user, you will need a password for this new MySQL user. If an existing MySQL user is selected, the “with Password” field is disabled and the existing password of this MySQL user is automatically used.

Copy database from MySQL 5.7 to MySQL 8.0

To copy a database from MySQL 5.7 to MySQL 8.0, proceed as follows:

1. Select version 5.7 in the Settings (Server -> MySQL).
2. Select the value “MySQL 5.7” for a site on the “Databases” tab in the “This site maps databases to” field.
3. Save the changes you have made.
4. Right-click on the desired database and select the option “Copy database ‘DATABASE NAME’ to MySQL 8.0…”.
5. A wizard is started which guides you through the copying process.

If you would like to copy all databases, click on the “Copy databases from v5.7 to v8.0…” button in the Settings (Server -> MySQL).