- Plesk for Linux
Pop-up occurs in accessible phpMyAdmin through Domains > example.com > Databases > exampledb > phpMyAdmin:
CONFIG_TEXT: 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:
CONFIG_TEXT: Connection for example_user 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.
#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 DirectAdmin
The expected behavior.
Passwords are encrypted using asymmetrical encryption and cannot be transferred. The password should be recreated in Plesk manually to access phpMyAdmin.
Apply one of the solutions below:
Go to Domains > example.com > Databases > exampledb > phpMyAdmin
Specify the correct password in the pop-up
Warning: In case any applications are using this database, assure that the password matches the one specified during the below steps.
- 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