cPanel MySQL Databases
Difficulty Level: Easy
-
Login to your cPanel Account
-
Locate the Databases section and click on MySQL® Databases shown below
- The screenshot shown below is what you will see after clicking MySQL® Databases from step 2 above
-
Create a Database Name First
-
Create a Database User and Password. We strongly suggest using the Password Generator. Do NOT create a weak password.
-
Scroll to the bottom and add the user to the database.
-
You’ll see the following screen and you’ll choose All Privileges.
Make sure you read the sections below about creating and adding your Database User to your Database
If you need any assistance, please submit a ticket for Technical Support
Difficulty Level: Easy to Medium
It’s important to periodically change the password for your Database Username to maintain strong security.
After you change this password, make sure you update any config file(s) for your website that depend on this password. Otherwise, your website will stop working.
To get started, login to your cPanel account.
Locate the Databases section and click on MySQL® Databases
On the MySQL® Databases page, scroll down until you see the Current Users section.
Locate the Username that you wish to update the password for and click Change Password
On the next screen, you’ll see 2 fields to enter your new password and confirm the new password. Then click Change Password.
We suggest using the password generator so that you have a strong and unique password. Copy and paste it into the config file(s) of your website that depend on it to make the database connection.
If you need any assistance, please submit a ticket for Technical Support
Difficulty Level: Easy
If you suspect your database may be corrupted, you may login to cPanel and use the Check Database feature to determine if any issues are present.
This process is easy to follow and does not require a backup of your database prior to running the check. To get started:
-
Login to cPanel
-
Find the Databases section and click on MySQL® Databases
- Scroll down to the section titled Modify Databases
-
The first option is Check Database
-
Choose the Database you would like to check and click the button
- If the system detects a problem in the database, it displays the name of the corrupt table.
- If the Check Complete message displays, the database functions correctly.
If no issues are detected, you may either check another Database or leave this screen. If an issue is detected, scroll down to the next section on this page to see how to repair it.
If you need any assistance, please submit a ticket for Technical Support
If there are any corrupted tables within your database, you will now want to repair them.
This process is easy to complete and does not require a database backup prior to starting.
-
Login to cPanel
-
Find the Databases section and click on MySQL® Databases
- Scroll down to the section titled Modify Databases
-
The second option is Repair Database
-
Choose the Database you would like to repair and click the repair button
- If the system cannot repair the database, it will attempt to determine the source of the corrupt data.
- If the Repair Complete message displays, the system successfully repaired the database.
Hopefully, cPanel was able to repair your database. If not, your problem may be more severe and you should contact a qualified developer to assist in resolving the issue for you.
If you need any assistance, please submit a ticket for Technical Support