cPanel - MySQL Databases Print

MySQL is the most popular Open Source SQL Database management system. To manage a huge volume of data efficiently, we store the data in tables, a group of many tables can be created in a single database. This interface allows you to create and manage the existing MySQL databases.

To create a new MySQL database, you need to open MySQL interface by clicking MySQL Databases link, which can be found in the Databases section of cPanel Home.

Create a New Database

When MySQL Databases interface will open, first thing you will see is Create New Database Section as shown below.

Add a Database User

To create a Database User, scroll down to the end in Interface of MySQL databases. There you will see MySQL users, under it there will be Add New User, as shown below.

Step 1 − Enter a username according to your choice and choose a strong password. Click Create User to create a new user. You will get a success message “You have successfully created a MySQL user.

Step 2 − Scroll down to find “Add User to Database”.

Step 3 − Select the User and database you wish to associate together. Click Add button and you will see the following screen.

To provide all the privileges to the user, select ALL PRIVILEGES checkbox and all the checkboxes will automatically get selected. Click Make Changes to save the changes.

Modifying a Database

There are two operations we can perform to troubleshoot database related errors. To perform these actions, we need to scroll to Modify Database Options in MySQL Database Interface, screenshot for Modifying Database is shown below.

Check a Database

With this feature of cPanel Database, you can find which table in the Database is corrupted.

To check a database, we need to perform the following steps.

Step 1 − Select the database you want to check, from the dropdown menu of Check Database, as shown above.

Step 2 − Click the Check Database button.

Step 3 − cPanel will now run an automated script to find the corrupt table in the Database. If any corrupt table is found, it will display the name of the Table, otherwise it will display a success message.

Repair a Database

This database tool helps in automatically repairing of corrupt data or table from the database.

To use this tool, we need to perform the following steps −

Step 1 − Select the database having corrupt data from the dropdown menu.

Step 2 − Click Repair Database button.

Step 3 − cPanel will now run an automatic script to repair the corrupt data or table from the database, if it succeeds, it will give you a success message. If it fails to repair the database, it will show you an error with the table name on which the error occurred.