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.
- Navigate to this directory in Windows Explorer: C:Program Files (x86)PleskDatabasesMySQL
- Insert skip-grant-tables option into my.ini file right under [MySQLD] section.
-
Start Plesk Services Monitor at Windows Start > All Programs > Plesk.
- Restart the "MariaDB106" service:
- Run cmd.exe from Administrator and open connection to database:
C:> "%plesk_dir%MySQLbinmysql" -P3306 -uadmin mysql
- Run this commands one-by-one:
C:> FLUSH PRIVILEGES;
C:> ALTER USER 'admin'@'localhost' IDENTIFIED BY "yournewpassword";
C:> FLUSH PRIVILEGES;
- In Plesk > Tools & Settings > Database servers > localhost > Administrator Password - type the same password as in step 5 and press Apply.
- Remove skip-grant-tables option from my.cnf file (from step 2).
- Restart MySQL/MariaDB instance once again as in p.4.
with