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

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: