Failed to login to the client’s MySQL using Plesk admin credentials

Symptoms

Failed to login to MySQL server which contains client databases with Plesk admin credentials.

Cause

During the installation client’s MySQL server creates the admin user with the randomly generated password.

Resolution

• In order to access the MySQL server which contains client databases use Webadmin or reset the password for this admin user.

  1. Log into Plesk

  2. Go to the Tools & Settings > Database Servers and click on the tools icon.

     

• In order to reset a password for the client’s MySQL proceed with the following:

  1. Log into Plesk

  2. Go to the Tools & Settings > Database Servers and click on localhost

  3. Click Change Password and enter the new password.