This article describes how to use cPanel to manage MySQL databases and users. You can add, modify, and delete databases and users, as well as manage user database permissions.
To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.
To create a MySQL database user, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
In the Password (Again) text box, retype the user 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:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
In the Password and Password (Again) text boxes, type the new password.
To rename a MySQL user, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
When you delete a user, the user and its database permissions are deleted.
To delete a MySQL user, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
After you create a database user, you are ready to create a database and associate the user with the new database.
To create a MySQL database, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
Click
To add a MySQL user to a database, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
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:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
To check a database:
If a database check indicates problems with a database, you can repair it:
When you revoke a database user's privileges, the user can no longer access the database. To do this, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
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:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click MySQL Databases:
For more information about MySQL, please visit http://www.mysql.com.
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.