Skip to content
MAMP PRO Documentation

Databases

MAMP PRO - 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 Transfer › Hosting and Transfer › Cloud features. This mapping tells MAMP PRO which site is associated with which database(s).

Create Database

Section titled “Create Database”

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

MAMP PRO - Databases - Create database

  • 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 the MySQL “root” user, which will also be granted all privileges for it. 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

Section titled “Copy database from MySQL 5.7 to MySQL 8.0”

  1. Select version 5.7 in 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 will start to guide you through the copying process.

To copy all databases, click the “Copy databases from v5.7 to v8.0…” button in Settings › Server › MySQL.