Creating MySQL Database and Users
 
Click to see a video walk-through to show you how to use this feature

 

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.