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
To create a MySQL database user, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Add New User, in the Username text box, type the MySQL username.
- In the Password text box, type the user password.
- In the Password (Again) text box, retype the user password.
- 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:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Current Users, locate the user for which you want to change the password, and then click Change Password.
- In the Password and Password (Again) text boxes, type the new password.
- Click Change Password. The new password takes effect immediately.
Renaming a user
To rename a MySQL user, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Current Users, locate the user that you want to rename, and then click Rename.
- 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.
To delete a MySQL user, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Current Users, locate the user that you want to delete, and then click Delete.
- 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
To create a MySQL database, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Create New Database, in the New Database text box, type the name of the database.
- Click Create Database. cPanel creates the database.
Adding a user to a database
To add a MySQL user to a database, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Add User to Database, in the User list box, select the user that you want to add.
- In the Database list box, select the database.
- Click Add.
- 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.
- 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:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- To check a database:
- Under Modify Databases, in the Check Database list box, select the database.
- Click Check Database.
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 Database.
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:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Current Databases, locate the user for which you want to revoke privileges, and then click the trash can icon.
- 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.
To delete a MySQL database, follow these steps:
- Log in to cPanel.
- In the DATABASES section of the cPanel home screen, click MySQL® Databases.
- Under Current Databases, locate the database that you want to delete, and then click Delete.
- Click Delete Database. cPanel deletes the database.