How to manage MySQL databases and users in cPanel

Managing database users

To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.

Creating a database user
  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:

  3. Under Add New User, in the Username text box, type the MySQL username.
  4. In the Password text box, type the user password.

  5. In the Password (Again) text box, retype the user password.

    You can click Password Generator and cPanel generates a random, strong password for you.
  6. Click Create User. cPanel creates the database user.

 

Changing a user's password

You can change a database user's password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.

To change a MySQL user's password, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Current Users, locate the user for which you want to change the password, and then click Change Password.

  4. In the Password and Password (Again) text boxes, type the new password.

    You can click Password Generator and cPanel generates a random, strong password for you.
  5. Click Change Password. The new password takes effect immediately.
Renaming a user

To rename a MySQL user, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Current Users, locate the user that you want to rename, and then click Rename.
  4. In the New name text box, type the new name, and then click Proceed. cPanel renames the user.
Deleting a user

When you delete a user, the user and its database permissions are deleted.

Make sure you do not have any applications that currently use the database user!

To delete a MySQL user, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Current Users, locate the user that you want to delete, and then click Delete.
  4. Click Delete User to confirm the deletion.

Managing databases

After you create a database user, you are ready to create a database and associate the user with the new database.

Creating a database
  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Create New Database, in the New Database text box, type the name of the database.
  4. Click Create Database. cPanel creates the database.
Adding a user to a database
  1.  Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Add User to Database, in the User list box, select the user that you want to add.
  4. In the Database list box, select the database.
  5. Click Add.
  6. Select the check boxes to grant the user specific privileges, or select the ALL PRIVILEGES check box to grant the user all permissions to the database.
  7. Click Make Changes. cPanel adds the user to the database.
Checking and repairing a database

You can check MySQL databases for errors or possible corruption. If a database check reveals problems, you can repair the database as well.

To check and repair a database, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. To check a database:
    • Under Modify Databases, in the Check Database list box, select the database.
    • Click Check Database.

  4. If a database check indicates problems with a database, you can repair it:

    • Under Modify Databases, in the Repair Database list box, select the database.
    • Click Repair Databases.
Revoking privileges from a database user

When you revoke a database user's privileges, the user can no longer access the database. To do this, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Current Databases, locate the user for which you want to revoke privileges, and then click the trash can cPanel - Databases - Delete icon icon.
  4. Click Revoke User Privileges from Database.
Deleting a database

Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.

When you delete a database, any associated users are not deleted. However, all privileges users have for that database are revoked.

To delete a MySQL database, follow these steps:

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click MySQL Databases:
  3. Under Current Databases, locate the database that you want to delete, and then click Delete.
  4. Click Delete Database. cPanel deletes the database.
  • database, add user, delete user
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to access phpMyAdmin and phpPgAdmin in cPanel

Accessing phpMyAdmin in cPanel Log in to cPanel. In the DATABASES section of the cPanel home...

How to configure remote MySQL access in cPanel

This article describes how to use cPanel to allow external hosts to access your MySQL databases....

How to use phpMyAdmin to copy a MySQL database

Copy MySQL database To copy a MySQL database using phpMyAdmin, follow these steps: Log in to...

How to change the MySQL collation settings in phpMyAdmin

About character sets and collation MySQL enables you to store and process data in a wide...

How to optimize and repair MySQL databases using phpMyAdmin

Optimizing MySQL databases Databases have the potential to grow very large, particularly on...

Powered by WHMCompleteSolution