To access the MySQL Account Maintenance Menu, click on the    icon above the words MySQL Databases on the main screen of your cPanel interface.

To Create a Database

1 Enter the name of the new database in the blank field next to Db:.

2 Click on Add Db to create the database.

To Create a User

1.Enter the name of the new user in the blank field next to UserName:

2 Enter the password for the new user in the blank field next to Password:

3 Click on Add User to create the new user.

Grant a User Permission to a MySQL Database

1 Select the user (the user will appear as mainuser_user) you wish to grant permissions for from the drop box next to User:

2 Select the database (the database will appear as mainuser_database) you wish to give that user access to from the drop box next to Db:

3 Select any privileges (abilities to modify the database) you wish the user to have by checking the box next to the privilege's name.

4 Click on Add User to Db to give the user permission to access the database.

phpMyAdmin

phpMyAdmin allows you to administrate all of your mySQL databases. To learn more about this tool, please look at the phpMyAdmin help page.

Removing a MySQL Database

Click on next to the name of the database you wish to delete. Note: Before deleting a database due to problems with that database, try using on the database to repair any problems with it.

Removing a MySQL User

1 Scroll down to the user's name under Users:

2 Click on next to the user's name to remove their MySQL user.