phpmyadmin rename database without dropping it

Here you need to find out the wp-config.php file. Therefore, it is necessary for you to make some changes in wp-config.php. However, it is not enough to make the change effective because you need to make the new database name match with the wp-config.php file. In fact, you can create a name absolutely depend on yourself as long as it consists of numbers and letters.Īfter clicking “Go”, the screen will jump out the tip to make sure that whether you want to make the change or not. After ensuring that you have typed correctly, find out the icon “Go” on the bottom right corner of the page and then click it. Then, click “operations”.Īs is shown in the picture, you need to enter your new database name into the blank field. Once you have selected the right database, click it and you will see the screen appear like the pictures below. Then you need to choose the one that you want to make a change of. Now you can see a list of your databases. Log into your cPanel and then click phpMyAdmin. To meet most people’s needs, we have drawn up the article about changing the database name through phpMyAdmin in cPanel.

We adopt cPanel in our Linux web hosting because it offers automation tools to make it easy to host a website and owns graphic interface. In addition, we have compiled an article to tell you some tips on how to change your database name through phpMyAdmin which is also helpful to reset WordPress password and import and export MySQL database. Besides, if you want to change your WordPress database name, you need to pay attention to the steps to avoid something wrong.Īctually, you should be clear about that all data in your database are very important for you, so it is very important to focus on its security and here we recommend you to choose a database name that is not easy to guess. The name should be easy for you to remember and at the same time, it should be different from others’. When it comes to choosing a name for your WordPress database, it is very important for you to create a unique name. WordPress database includes all data saved in a web server.

Phpmyadmin rename database without dropping it