Symptoms
-
Pop-up occurs when a database is accessed via working phpMyAdmin using Domains > example.com > Databases > exampledb > phpMyAdmin link:
Enter the password to log in as the database user example_user.
-
phpMyAdmin shows one of the following errors on attempts to access the database directly:
Connection for example_user as defined in your configuration failed
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) -
Might be experienced after migration from Cpanel or DirectAdmin
Cause
The expected behavior.
Passwords are encrypted using asymmetrical encryption and cannot be transferred. The password should be recreated in Plesk manually to access phpMyAdmin.
Resolution
Apply one of the solutions below:
Specify the correct password in the pop-up
-
Go to Domains > example.com > Databases > exampledb > phpMyAdmin
-
Specify the correct password in the pop-up
Specify the new password via Plesk
Warning: In case this database is being used by any application, make sure that the password matches with the one specified during the procedure below.
- Log into Plesk
- Go to the Domains > example.com > Databases > User Management > example_user
- Specify a new password (or click on the Generate button)
- Click the OK button
with