I have an issue with the use of my databases. I can see from the CP that mariadb (in Services) is up and working properly. I have basically about 10 different databases for my user. Yesterday evening I created a new database that I need for another project. To consider that I have the same password for 9 databases. I chose to have a different password for this new (10th) database, but unfortunately also the password of the other 9 has changed. So if I change the password for one, also all the other change regardless of which one. Is this how databases are supposed to work or I am doing anything wrong? I thought I could have different passwords for different database.
Thank you for answering. I created the database through the Panel (DB) since itās very easy and quick there. Now I changed the password for one, and all the databases work again, but Iām obliged to have the same password for all the databases, canā't change only for a single one. If could suggest any troubleshooting I would be glad to do it.
Hi, I changed the password for the database elliot_LAB and verified that the others were not reachable anymore, then I changed the password of elliot_woo to reinstate the old one for all.
Here is the log:
2023-02-22 14:18:49 v-change-database-password āelliotā āelliot_LABā āā
2023-02-22 14:20:20 v-change-database-password āelliotā āelliot_wooā 'ā
When I create a database with my user elliot, I add the database name in āDatabaseā, like Woo for example, and I add admin in Username. I confirm that all the databases have the username admin, but this shouldnāt make any difference since the database name is different, correct? I add info like in the following screenshot:
Ok, thank you very much. Would be useful for your report if I change the username for all and then I tell you if this worked? Or you prefer that I wait for the bug to be fixed?
We might call it a feature if you want to use the same username you to update for all we probally add an warning + update the password for all databases at the same time
Thank you very much Eris, you have been great. I will probably change username only for the account where I need a different password, and I will let you know if that worked well. Iāll try this weekend and Iāll reply here to confirm.
Hi eris, Iāve just tried, I changed the username first from āadminā to ārenatoā and saved. DB all worked. Then I changed the password only for this DB with different username, and all the other stopped working until I had to reset to the old password. The solution was to create a new database with different username and different password from the beginning, this worked, the other DB havenāt been affected. I also tried to change the password for the new DB and everything is ok, it change it only for the new one. Basically if you create a DB with the same username you canāt make it independent anymore, it will always be related to the others even if you change username. Maybe you could add to your bug report (feature requests) the chance to make a DB independent if the user wants.