If you have lost access to MySQL admin Password and can't connect to it using plesk wedadmin interface, you will get get the follwing 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)\Parallels\Plesk\Databases\MySQL\data
  • 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. 

Bacl to Plesk

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-2) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 2283

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1