The databases store all the information that an installation needs to function, be it data related to the configuration of extensions, plugins, modules, or the themes / templates in use, as well as data generated by users. One of the tasks that can be performed is change the database password, if it contains special characters that may cause problems or for other needs.
You have moved an installation from one Hosting to another Hosting, you cloned a website for testing, you restored a backup, … there are many everyday scenarios that may lead you to have to change the password of a database in an installation of any manager of content that you use regularly.
Performing the password change is a quick and easy process if it is clear where and how to do it in the correct way without affecting other databases (if you have multiple installations). Read on if you want to know how to do it!
Where to locate the data of the database in use?
It is a topic already explained in other blog articles, which I recommend you read to know where to find this data based on the content manager you use, be it WordPress, Joomla, PrestaShop, Moodle or others.
This point is important, since it is necessary, especially if you have several installations, that you know which databases correspond to each installation, so that you do not modify the one that does not correspond.
How to change the password of the database?
It is always recommended to make a backup from the database, from your Hosting panel, Databases, phpMyAdmin, opening the database from which you will modify the password and clicking on the top menu To export and downloading the file .zip or .sql to your computer.
Then the database password must be changed from the Hosting panel (cPanel), Databases, MySQL Databases.
On the bottom, Current users for the database user whose password will be modified by clicking on Set password.
- Both (aBcD)
- Numbers (123)
And then it generates the password to use for the database, writing it down, since it will be necessary for the data configuration file of the database of your CMS, so that your web application connects correctly with the database.
As you can see, it is an extremely simple process, in which it is convenient to be clear about the importance of using passwords that later do not cause conflicts in your content manager, and that I illustrate in this video so that you see it even more clearly.
From now on you will have clearer how the changing password of a database, whatever the web application you use.
Member of the Websites Are Us technical team.
Coordinator of content on the Blog and YouTube.
Technical support in CyberProtector. Teacher at Websites Are Us Learning.