mySQL Databases in cPanel

This article covers mySQL Databases in cPanel.

1. Log in to your cPanel: www.YOURDOMAIN.com/cpanel

2. Click on “MySQL Databases” under the Databases section.

   

3. You can now use the available options to perform various MySQL-related tasks within cPanel including:

   • Create a new database:

     1. Under the section Create New Database, enter the name for the new database.

        

     2. Click “Create Database”

     3. You will see a confirmation saying the database was created.  Click “Go back”.

     4. The new database will now appear in the table of current databases.

        

   • Create a new user:

     1. Under the section MySQL Users, enter the name for the user.

        

     2. Create a password.

     3. Click “Create User”.

     4. You will see a confirmation saying the user was created.  Click “Go Back”.

     5. The new user will now appear in the table of current users at the bottom.

        

   • Add a user to a database:

     1. Under the section Add User to Database, select the user and the database you want to add it to.

        

     2. Click “Add”.

     3. A new page will load with the user privileges for the database. Select the privileges desires.

        

     4. Click "Make Changes" at the bottom.

     5. You will see a confirmation saying the user was added.

     6. Click “Go Back”.

     7. The database will now show the correct user in the table of current databases.

        

   • Check and repair a database:

     1. Under the section Modify Databases, you can check and repair a database.

        

     2. Select the database you would like to check or repair and select the appropriate action you would like to take, “Check DB” or “Repair DB”.

   • Remove a database:

     1. Under the section Current Databases, there is a table that shows the databases and users you currently have.

     2. Find the database you want to remove and click on “Delete Database”.

        

     3. You will be asked to make sure that you want to remove the database, click “Delete Database”.

     4. You will see a confirmation that the database was removed.  Click “Go Back”.

   • Remove a user:

     1. Under the section Current Users, there is a table that shows the users you have available.

     2. Find the user you want to remove and click on the icon with an “X”.

        

     3. You will be asked to make sure that you want to remove the user, click “Delete User”.

        

     4. You will see a confirmation that the user was removed.

     5. Click “Go Back”.