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 RepairDatabase 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.
Was this answer helpful? 0 Users Found This Useful (0 Votes)