Settings > Hosts > Databases

The Database tab indicates which databases are associated with each host. You can associate individual databases or tables with a host. Disabled checkmarks indicated databases and tables that are mapped to a host via an Extra or automatic WordPress install. This association cannot be broken.

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

MAMP PRO - Databases

Create database

To create a new database click on the “+” button at the bottom of the databases table. You can only create databases, not individual tables. To do this, please use a database administration tool such as phpMyAdmin. You can access phpMyAdmin by clicking the corresponding icon in the footer of the database table.

MAMP PRO - Databases - Create database

  • Name
    Here you enter the name of the new database.

  • After creating the new database…

    • grant access to User
      If this box is not checked (default), the new database will be created by and rights given to the MySQL “root” user. When you do grant access, you have the choice of using an existing user, or your can create a new user.

      • If you choose to create a new MySQL user, a password for this new MySQL user is required. This must be filled in below in the “with Password” text field. The newly created MySQL user has all privileges only for the newly created database. For all other databases he has no privileges.

      • If an existing MySQL user is chosen, the “with Password” field is disabled and the existing password of this MySQL user will automatically be used.

    • with Password
      Here you enter the name of the new MySQL user. When a new MySQL user is created a password is needed to continue. This field is disabled if an existing user is used.