A migrated database in Plesk cannot be accessed via phpMyAdmin: Access denied for user

Symptoms

• Pop-up occurs when a database is accessed via working phpMyAdmin using Domains > example.com > Databases > exampledb > phpMyAdmin link:

  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.
  
  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: