How to rename a MySQL database name?

A database name can be renamed. This is usually done when you want to change database configurations or you have unwanted database access from previous or old users. Please follow the instructions below on how to rename a MySQL database name.

Rename a MySQL database name via cPanel

Step 1. Log in to the cPanel.

cPanel-Login-SS | MySQL

Step 2. Under Databases panel, click on MySQL® Databases.

MySQL

Step 3. Scroll down to Current Databases and click on Rename along the database name you want to modify.

database-rename

Step 4. Enter the new database name and click on Proceed button to save the changes.

(Note: A reminder about backing up your database must be done before renaming it will prompt. If you want to perform a backup you may do it first before you proceed. In this case click on Cancel button. You can do a backup either through exporting database via phpMyAdmin or download the backup database via Jetbackup. If you are done with the backup, you may now proceed with the renaming process.)

 

database-name-renamed

In this example, vodienfo_test is changed to vodienfo_testing and the MySQL database has been successfully renamed.

renamed-database

 

Do not hesitate to contact our support team if you have further questions.

Rename a MySQL database name

(Visited 19 times, 1 visits today)

Leave A Comment?