Category: MySQL Plesk SQL Windows
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)
Solution
Windows Configuration:
- 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;
Plesk Configuration:
* 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