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 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.
cPanel Databases
cPanel Databases
Notice that you can use this tool for both MySQL and MariaDB servers.

Related KB: How to use the cPanel MySQL Database Wizard

Share this post: