You can follow one of the below instructions to rename a MySQL database with the help of cPanel, phpMyAdmin, or command line as per the availability. After renaming the database, remember that you need to reconfigure the permission on the new database for the users. In this tutorial, you will find three methods to rename a MySQL database.
Method 1 – Rename MySQL Database with Command Line
As you know that there is no direct command or SQL statement available for renaming the database in the MySQL server. But you can still change the database name using backup and restore options. You have a new database with a new name. Verify the new database and make sure that restore completely and functioning properly.
Method 2 - Rename MySQL Database with phpMyAdmin
phpMyAdmin is the most popular web application used for managing MySQL databases. It provides you an option to rename the database in the MySQL server. All done. Here phpMyAdmin will create a new database with a new name and copy all content from the old one. After that drop the old database.
Method 3 - Rename MySQL Database with cPanel
cPanel is a web-based control panel for the CentOS and Redhat Linux systems. It is popular among shared hosting providers. You can easily rename a MySQL database with the help of cPanel. The cPanel offers the easiest way to rename a MySQL database. That’s it. You have successfully renamed a MySQL database.
Conclusion
This guide helps you to understand how to rename MySQL databases. You will have to reconfigure the user permissions since the database has been renamed.
