Creating MySQL Database and Its Users
 

MySQL users cannot exist separately from MySQL databases. You must conform to the following sequence:
 

1. Create a database

2. Add MySQL users to each created database.

However, MySQL users can be shared by different databases.
 

To create a MySQL database, do the following:

1. Select MySQL in the Databases menu and a MySQL DB creation Wizard automatically appears.

2. On the form that shows enter the name of the database and database description if needed:
 

3. Agree with additional charges if any.

4. In the form that appears, create a new user or grant privileges to users of other databases:
 

*Add a new user to the database you have just created. Click Add user.

*Choose roles for users of other databases so they can use your new database. Click Grant.

5. Click Finish to complete creating your MySQL database.