If you have lost access to MySQL admin Password and can’t connect to it using Plesk web admin interface, you will get get the following error:
Welcome to phpMyAdmin You probably did not create a configuration file. You might want to use the setup script to create one. Error MySQL said: #1045 - Access denied for user 'admin'@'localhost' (using password: YES)
- Open the file ‘my’ in the following directory:
C:Program Files (x86)ParallelsPleskDatabasesMySQLdata
- Add ‘skip-grant-tables’ under mysqld group at the top of the page
* Restart mysql
Now you can login to MySQL without any password.
>> mysql -uadmin -p >> use mysql; >> UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'admin'; >> flush privileges;
* Login to Plesk * Click on 'Server' at the top right panel * In the 'Application & Databases' section, click on 'Database Servers' * Click on 'Local MySQL Server' * Click Settings and change the password to 'New Password' configured for admin in windows.
- Back to Plesk