Central Management of Your Databases
While the Wizard is ideal for getting started, the "MySQL Databases" overview gives you full control over existing structures. Here you can fix errors, fine-tune user privileges, and perform maintenance tasks.
Database Maintenance: Check & Repair
Is your website lagging or showing database errors? cPanel offers built-in tools for a quick fix:
The system scans all tables for inconsistencies. If "Check Complete" appears, everything is structurally sound.
If a check revealed errors, this tool attempts to automatically restore corrupted table indexes.
Managing Users and Privileges
A common cause of problems is missing user privileges. Here is how to assign a user correctly:
- Scroll to the "Add User To Database" section.
- Select the desired user and the target database.
- Click Add.
- In the next window, select the privileges (usually "ALL PRIVILEGES" for CMS like WordPress) and save.
Renaming or Deleting Databases
In the "Current Databases" table, you can see the size of your data at a glance.
- Rename: cPanel copies the data to a new database and deletes the old one. Warning: You must then manually update the name in your website configuration (e.g., wp-config.php)!
- Delete: This process is final. Be sure to create a backup first.
Remote MySQL
If you want to access your database from an external server or a local application (e.g., MySQL Workbench), you will find the necessary host address here. Ensure that your local IP address is whitelisted in cPanel under "Remote MySQL".
Need help with a complex database migration?
The CURIAWEB support team is happy to advise you on all questions regarding your MySQL environment!
