Renaming a MySQL database in cPanel is a common task, especially when migrating your website or cleaning up database naming conventions. Thankfully, cPanel provides a built-in option to rename databases quickly and without needing to write any SQL queries.
Note: Before renaming a database, make sure to take a full backup of the existing MySQL database. It’s a best practice to prevent accidental data loss.
Steps to Rename a MySQL Database from cPanel
Step 1: Log in to your cPanel account.
Step 2: Navigate to the Databases section. Click on MySQL Databases.
Step 3: Scroll to the Current Databases section. Use the search feature to find the database you want to rename.
Step 4: In the Actions column next to the database, click the Rename button.
Step 5: A Rename Database dialog box will appear. Type in your desired new name for the database, then click the Proceed button.
Step 6: Once the action is completed, you’ll receive a confirmation message stating that the database name has been changed successfully.
Conclusion:
Renaming a MySQL database from cPanel is fast, efficient, and doesn’t require any command-line work. This feature is especially useful during hosting migrations or site restructures. Just don’t forget to update your application’s configuration files with the new database name, especially if you’re working with WordPress or any CMS that uses a database connection string.
