• At the left side bar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find list of all the databases, and select appropriate database that you want to repair and it would be expanded

• Scroll below and then click ‘check all’, after that click the drop-down option and select ‘repair tables’

If the table has repaired successfully, it would show an ‘Ok’ message, otherwise it may show some error like ‘error unknown engine’ etc

• At the left sidebar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to optimize and it would be expanded

• Scroll below and then click ‘check all’, after that click the drop-down option and select ‘optimize tables’

It would be optimized successfully.

• At the left sidebar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to edit and it would be expanded
• Select the desired table you need to delete, for example, if you want to edit the WordPress table and change the name of the blog from phpMyAdmin then choose “wp-options”.

• Click the delete button present in 3^rd row

• Scroll down and then click on delete.

• At the left sidebar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find the list of all the databases, and select an appropriate database that you want to edit and it would be expanded
• Select the desired table you need to edit, for example, if you want to edit the WordPress table and change the name of blog from phpMyAdmin then choose “wp-options”.

• Click the edit button present in 3^rd row

• At the left sidebar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find the list of all the databases, and select the appropriate database that you want to export it to the PC

• Click the export button,

Select SQL format and then choose the Go button

• At the left sidebar, you will click on the expand button to expand your database like ‘example’.

• Under the cPanel username, find a list of all the databases, and select the appropriate database that you want to import SQL.
• Click the import button,

• Find ‘file to import’ choose the browse button and select SQL file from the PC.

• Scroll down and then choose the Go button

• Scroll to the bottom of your page and find ‘add a user to database’, choose a relevant user from the drop-down list and then select the required database.
• Click on the ‘Add’ button

• You will find ‘manage user privileges’, then mark the box ‘add privileges’ click ‘make changes’

• Find ‘MYSQL users’ in the usernames area and then add the new name you want to create.
• Enter the new strong password or use a password generator
• Then click on ‘create a username’ button

• Find ‘current databases’ to check out the list of all databases and then choose the option ‘delete’.

• Click the ‘delete database’ button
• If you see a warning, again click the ‘delete database’ button

• Find ‘current databases’ to check out the list of all databases and then choose the option ‘rename’.

• Change the name of the database and then click the ‘proceed’ button.