Settings > Hosts > Databases
The Database tab shows which databases are associated with each host. You can associate individual databases or tables with a host. Disabled check marks indicate databases and tables that are mapped to a host via an Extra.
New Database
Press the ‘+’ button to add a new database. Only databases can be added, not individual tables.
-
New Database Name
This is the name of your MySQL database.
-
Give access to user.
When you grant access, you have the choice of using an existing user or creating a new user. If you choose to create a new MySQL user, you will need a password for this new MySQL user. This must be entered in the “Use password” text box below. If an existing MySQL user is selected, the “With password” field is disabled and the existing password of this MySQL user is automatically used. If this box is unchecked, the new database will be created by and granted rights to the MySQL “root” user.
-
Use password
The password of your MySQL user. When a new MySQL user is created, a password is required to proceed. This field is disabled if an existing MySQL database user is creating the database.