Creating MySQL Database and 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. (NOTE: MySQL users can be shared by different databases.)
 
To create a MySQL database:

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. 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. 

4. Click Finish to complete creating your MySQL database.