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).
Press the ‘+’ button to add a new database. It is only possible to add databases, and not individual tables.
Name of new database
This is your MySQL database name.
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 “Using 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 “Using password” field is disabled and the existing password of this MySQL user will automatically be used.
The password for your MySQL user. When a new MySQL user is created a password is needed to continue. This field is disabled if an existing MySQL database user is creating the database.