Plesk for Windows
kb: technical
ABT: Group A
Applicable to:
- Plesk for Windows
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)\Plesk\Databases\MySQL
- 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%\MySQL\bin\mysql" -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.
Comments
0 comments
Please sign in to leave a comment.