How to rename a database in phpMyAdmin?

phpMyAdmin is a free and opensource application for MySQL database management. It is one of the most popular web-based MySQL management tools for web hosting services.  Written in PHP, phpMyAdmin gives users the ability to interact with their MySQL databases.

Quick Steps

  1. Go to cPanel > Databases > phpMyAdmin
  2. Select database you wish to rename from the left hand column.
  3. Click on the Operations tab.
  4. Under the field “Rename database to:” enter the new database name.
  5. Click the Go button.
  6. Click OK to proceed
  7. Once the operation is complete, click OK when asked if you want to reload the database.

Note : Keep in mind that when you change the name of a database, you will have to reconfigure user permissions to continue referencing this database.

Re-configuring User Permissions.

We’ll need to reconfigure the user permissions, since the database has been renamed. Go back to the main cPanel page and click on MySQL Databases.

Scroll down to the Add User To Database section of the page. From the list, select the renamed database and the database user that used to be associated with this database. Then, click on the Add button. 

On the Manage User Privileges page, check the box next to All Privileges  and click on the Make Changes button.

  • rename database
  • 1 Users Found This Useful
這篇文章有幫助嗎?

相關文章

How to show hidden files (.htaccess) in cPanel File Manager?

Many users ask us how they can see the .htaccess files for their websites in cPanel File Manager....

How Can I Compress / Uncompress Files Using the File Manager?

How to Compress Files Go to the File Manager. Navigate to the folder where the files you want...

How to View Your cPanel Disk Space Usage?

In order to view your cPanel disk space usage, there’s a great tool located inside of your...

Accessing webmail for your domain

To access the included webmail email clients included with your hosting account, you’ll need to...

Import / Export a mySQL database using cPanel & phpMyAdmin?

This tutorial assumes that you have already created a database. If you have not, you will need to...