phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel or Plesk, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats.

Video: https://youtu.be/stPfoIZUIbg

To set up a database, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – In the New Database text box, enter a name for the database and click Next Step.
4 – Click Create Database. A new interface will appear.
5 – Click Go Back. The new database appears in the Current Databases table.

To check a database for errors, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – In the Check Database menu, select the database that you wish to check.
4 – Click Check Database. A new interface will appear, and the system will check whether the database functions correctly.
* 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.
5 – Click Go Back to return to the main interface.

If one of your databases is corrupt, To repair a database, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – In the Repair Database menu, select the database that you wish to repair.
4 – Click Repair Database. A new interface will appear, and the system will attempt to automatically repair the database.
* 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.
5 – Click Go Back to return to the main interface.

The Current Databases table lists the following information for each database in your account.
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

* Database — The name of the database.
* Size — The size of the database.
* Privileged Users — The users who can manipulate the database.

To rename a database, perform the following steps:
1 – In the Current Databases table, click Rename for the desired database.
2 – Enter the new database name in the New name text box.
3 – Click Proceed.

To delete a database, perform the following steps:
1 – In the Current Databases table, click Delete for the desired database.
2 – To permanently delete the database, click Delete Database.
3 – Click Go Back to return to the main interface.

After you create a database, add users to the database and configure their privileges.
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – Enter a username in the Username text box.
4 – Enter and confirm the new password in the appropriate text boxes.
5 – Click Create User.
6 – Click Go Back to return to the main interface.

To add a user to a database, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – In the Add User To Database section of the interface, select the desired user and database from the menus.
4 – Click Add. The MySQL Account Maintenance interface will appear.
5 – Select the checkboxes that correspond to the privileges that you wish to grant to the user.
6 – Click Make Changes.
7 – Click Go Back to return to the main interface.

The Current Users table lists all of your MySQL database users, and allows you to perform the following actions:
1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

* Change Password — Click to modify a database user’s password. Enter and confirm the desired password, and then click Change Password.
* Rename — Click to rename a database user. Enter the desired username, and then click Change Username.
* Delete — Click to permanently delete a database user, and then click Delete User to continue.

Video: https://youtu.be/stPfoIZUIbg

This wizard guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. 

To set up a database, perform the following steps:

1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – In the New Database text box, enter a name for the database and click Next Step.

4 – In the Username text box, enter a name for the user who you wish to allow to manage the database.

5 – Enter and confirm the new password in the appropriate text boxes.

6 – Click Create User.

7 – Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.

8 – Click Next Step.

The system displays a message that states that you successfully set up the database and user account.

After you complete the database setup process, select one of the following options:

• Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.
• Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.
• Return to Home — Click to return to the cPanel Home interface.

Video: https://youtu.be/stPfoIZUIbg

This feature allows remote hosts (servers) to access MySQL® databases on your account. This is useful, for example, if you wish to allow shopping cart or guestbook applications on other servers to access your databases.

To specify remote hosts that can access MySQL databases on your account, perform the following steps:

1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – Enter the host’s name or IP address in the Host text box.

4 – Click Add Host.

To deny database access to a remote host, perform the following steps:

1 – Open cPanel (yourdomain/cpanel).

2 – Click on (MySQL® Databases) from Databases section.

3 – Click Delete next to the host’s name or IP address.

4 – Click Yes.