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

Dmitry Bystrov

8 months ago

Symptoms

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

During the installation client's MySQL/MariaDB server creates the admin user with the randomly generated password.

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.

0 Shares