Working with cPanel MySQL Databases

cPanel allows you to easily manage your databases and users.

Necessary steps to add a new database:

1. Log in to cPanel
2. Look for MySQL® Databases (DATABASES section)
3. Look for Create New Database section. Enter your desired database name and click the Create Database button. The database will be created, a confirmations message will be displayed: Added the database “database_name”.

To check/repair a database:

1. Log in to cPanel
2. Look for MySQL® Databases (DATABASES section)
3. Go the Modify Databases section
4. Select from the drop-down list the database you want to check(or repair).
5. Click the Check(or Repair) Database button. In case of an issue, you will see them. In case everything is fine, a success message will be displayed: Success: Check/Repair Complete!

To add a new user to the MySQL/MariaDB server:

1. Log in to cPanel
2. Look for MySQL® Databases (DATABASES section)
3. Go the Modify Databases section
4. Look for MySQL Users->Add New User section
5. Enter the Username and Password.
6. Click the Create User button. The new user will be created, you will see a confirmation message: You have successfully created a MySQL user named “username”.

To add a user to a database:

1. Log in to cPanel
2. Look for MySQL® Databases (DATABASES section)
3. Go the Modify Databases section
4. Look for MySQL Users->Add User To Database section
5. Choose the User and the Database from the two drop-down lists.
6. Click the Add button.
7. Choose the privileges you want to give to the user.
8. Click the Make Changes button.