To add or delete information in existing databases, copy a database, or run MySQL queries and scripts, use cPanel’s phpMyAdmin interface (cPanel » Home » Databases » phpMyAdmin).
This section provides the remote MySQL server’s address configured by your hosting provider. You can use this host to connect to the MySQL server.
To rename a database, perform the following steps:
Warning:
Don’t use phpMyAdmin to create databases or database users. phpMyAdmin doesn’t map databases, which causes backups and restorations to not function.
Create a database
To create a database, perform the following steps:- In the New Database text box, enter a name for the database.
Note:If your hosting provider has enabled database prefixing, a prefix based on your account username and underscore character (
_) will precede the New Database text box. The system automatically prepends this prefix to the database name. - Click Create Database. A new interface will appear.
- Click Go Back. The new database appears in the Current Databases table.
Remote MySQL Host
Note:
This section only appears if a remote MySQL configuration exists.
Modify Databases
If you experience problems with a database, check your databases for errors.Check a database
To check a database for errors, perform the following steps:- In the Check Database menu, select the database that you wish to check.
- 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.
- Click Go Back to return to the main interface.
Repair a database
If one of your databases becomes corrupt, you can attempt to repair it. To repair a database, perform the following steps:- In the Repair Database menu, select the database that you wish to repair.
- 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.
- Click Go Back to return to the main interface.
Current Databases
The Current Databases table lists the following information for each database in your account:- Database — The name of the database.
- Size — The size of the database.
- Privileged Users — The users who can manipulate the database
Note:
When you modify database users, make certain that you modify the user’s access to the correct database. Users may have access to more than one database.
-
- To remove a user from a database, click the trash can icon (
) for the desired user, and then click Revoke User Privileges from Database. - To modify a user’s privileges for a specific database, click the desired username, select and deselect checkboxes to configure the desired privileges, and then click Make Changes.
- To remove a user from a database, click the trash can icon (
- Actions — The available actions for this database. Click the appropriate icon in this column to rename or delete a database.
Rename a database
Warning:
- It is potentially dangerous to rename a MySQL database. We strongly recommend that you perform a backup of the MySQL database in cPanel’s Backup interface (cPanel » Home » Files » Backup) before you attempt to rename it.
- When you rename a database, the system terminates all active connections to the database.
- You must manually update configuration files and applications to use the new database name.
- The system requires more time to rename larger and more complex databases.
- In the Current Databases table, click Rename for the desired database.
- Enter the new database name in the New name text box.
- Click Proceed.
- The system creates a new database.
- The system moves data from the old database to the new database.
- The system recreates grants and stored code in the new database.
- The system deletes the old database and its grants.
Warning:
- If any of the first three steps fail, the system returns an error and attempts to restore the database’s original state. If the restoration process fails, the API function’s error response describes these additional failures.
- In rare cases, the system creates the second database successfully, but fails to delete the old database or grants. The system treats the rename action as a success; however, the API function returns warnings that describe the failure to delete the old database or grants.
Delete a database
To delete a database, perform the following steps:- In the Current Databases table, click Delete for the desired database.
- To permanently delete the database, click Delete Database.
- Click Go Back to return to the main interface.
Add a MySQL user
After you create a database, add users to the database and configure their privileges.Note:
- You must create MySQL user accounts separately from mail and web administrator accounts.
- You must create a user before you can add the user to an existing database.