Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
phpMyAdmin shows the following errors on attempt to access the database through Plesk at Domains > example.com > Databases > exampledb > phpMyAdmin:
CONFIG_TEXT: Connection for exampleuser as defined in your configuration failed
CONFIG_TEXT: You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said:
#1045 - Access denied for user 'exampleuser'@'localhost' (using password: YES)
mysqli_real_connect(): (HY000/1045): Access denied for user 'exampleuser'@'localhost' (using password: YES) - Repair Kit error:
CONFIG_TEXT: The user johndoe on the subscription example.com is unable to connect to the database server.
Cause
Password for the database user was modified directly in the database server, therefore Plesk has outdated password stored for the phpMyAdmin connections.
Resolution
Password for the database user should be updated in Plesk:
Note: In case any applications are using this database, the new password must match the one specified in the next steps.
- Log into Plesk
- Navigate to the Domains > example.com > Databases > User Management > exampleuser
- Specify a new password, or click on the Generate button
- Click on Ok
-
Run the following command in the console:
# plesk bin database --update-dbuser exampleuser -passwd 'new_password' -server localhost:3306
Note: In case password for the remote database user should be updated, its host and port should be specified instead in the
-server
option.
Comments
2 comments
Hm, ...wondering
Before, with WHM, no problem at all, easy access all databases via phpMyAdmin.
Now after I'd moved to Plesk, within one domain I can:
I try to wrap my brain around that puzzle but am unable to come up with an explanation.
Thanks
Figured it out.
IC, MySQL on Plesk behaves totally different.
I went into user management of One database, which always asked me for login details when trying to access phpMyAdmin within Plesk, and tried to change password (very slightly, though) and the I couldn't save it. Got a warning the the password is too weak, according to MySQL rules.
AHA, there we go. Changed it to a complete different PW but Most Important, at a strength level MySQL could accept and look at that, Now I can access the database using the phpMyAdmin link in Plesk.
A simple solution but one needs to know that.
Admin, perhaps you can use this info for the other people with the same or similar issue.
You may mark this post as solved.
Cheers.
Please sign in to leave a comment.