Phpmyadmin rename database how to#
Phpmyadmin rename database update#
You may also need to update all the scripts or applications to continue accessing the renamed database.
The database should now have the new name. Managing user privileges in cPanel for MySQL databases. Lets learn how to rename database tables. For this tutorial, we will use a database with one table for an example. We will assume that you are already logged in to phpMyAdmin. On the Manage User Privileges page, check the box next to All Privileges and click on the Make Changes button. The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin.
Reconfigure permissions for the database user in cPanel. From the list, select the renamed database and the database user that used to be associated with this database. Scroll down to the Add User To Database section of the page. Go back to the main cPanel page and click on MySQL Databases. We’ll need to reconfigure the user permissions, since the database has been renamed. That’s it! The database has been renamed to “ test” as shown below,ĭatabases list in phpMyAdmin. Select the database you wish to rename from the left hand column and then click on Operations.Įnter the new database name in the field “ Rename database to:” and click Go.Ĭlick OK to proceed when it asks if you to want to create the new database and drop the old database. Go to cPanel > Databases and click on phpMyAdmin. 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. Step 7: Once the operation is complete, click OK when asked if you want to reload the database. Step 4: Under the field “ Rename database to:” enter the new database name. Frequently used operations (managing databases, tables, columns, relations, indexes, users. Step 2: Select database you wish to rename from the left hand column. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Step 1: Go to cPanel > Databases > phpMyAdmin