Plesk Onyx for Linux
kb: technical
ABT: Group A
Applicable to:
- Plesk Onyx for Linux
Symptoms
Accessing phpMyAdmin for a database from Plesk in Domains > example.com > Databases fails:
CONFIG_TEXT: Cannot connect: invalid settings
Cause
Mismatch of the database user's password saved in Plesk and in MySQL server.
Resolution
-
Go to Domains > example.com > Databases.
-
Under a database name, click on the name of a database user:
-
Specify a new password in fields Password and Confirm password.
-
Click OK or Apply to save the changes.
Comments
2 comments
I have a similar issue but for many databases migrated accounts from Cpanel, can you help me with a CLI fix so I don't have to fix manually for more than 200 databases users have?
Some times I have this error and some times I have another promtp to enter password manually for database at phpmyadmin, I reinstalled phpmyadmin and used plesk repair db and all without success, please help?
Hello Fouad Ahmed Fouad,
It is possible to change the password by using the next command:
# plesk bin database --update-dbuser jdoe -passwd pa$$w0rd
Additional information can be found here:
https://docs.plesk.com/en-US/obsidian/cli-linux/using-command-line-utilities/database-databases.75671/
Also, it can be checked via the help option:
# plesk bin database --help
Please sign in to leave a comment.