How to rename a database in phpMyAdmin

We all are familiar with phpMyAdmin, it is a free and open source application for MySQL database management. Here we are going to see how to rename a MySQL database name in phpMyAdmin.

Here are quick steps

  1. Go to cPanel > Databases > phpMyAdmin
  2. Select database you wish to rename from the left hand column.
  3. Click the Operations tab.
  4. Under the field “Rename database to:” enter the new database name.
  5. Click the Go button.
  6. Then Click OK in confirmation dialog to proceed

That’s all. But remember, after renaming database, you will have to reconfigure user permissions to access this database.