Symptoms
Failed to login to MySQL/MariaDB server which contains client databases with Plesk admin credentials.
Cause
During the installation client's MySQL/MariaDB server creates the admin user with the randomly generated password.
Resolution
In order to access the MySQL/MariaDB 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