tips.paddyonline.net

Fix wrong password in registry.

1. D:\Program Files\SWsoft\Plesk\admin\bin>plesksrvclient -get to get the Plesk admin password
("PASSWD" in following text).

2. Checked the DB user name for Plesk DB in registry in
"HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config\PLESK_DATABASE_LOGIN" value.
It was set to "admin"

3. D:\Program Files\SWsoft\Plesk\admin\bin>"../../mysql/bin/mysql" -uadmin -p"PASSWD" -P8306 ERROR 1045 (28000):
Access denied for user 'admin'@'localhost' (using password: YES)

4. Modified the Plesk MySQL "D:\Program Files\SWsoft\Plesk\MySQL\Data\my.ini" file and added option
"skip-grant-tables=1" to be able to login to MySQL without password.
Restarted Plesk MySQL server for changes to take effect.

5. Logged in to MySQL on port 8306 (which is used for Plesk), and checked what users have access:
D:\Program Files\SWsoft\Plesk\admin\bin>"../../mysql/bin/mysql" -uadmin -P8306
mysql> use mysql;
Database changed
mysql> select * from user;

Host	User	Password	Select_priv	Insert_priv	Update_priv	Delete_priv
localhost	admin1	3d89770b0d299d60	Y	Y	Y	Y

1 row in set (0.01 sec)

6. Set correct username in registry (changed to "admin1").

7. Modified Plesk MySQL "my.ini", set "skip-grant-tables=0" and restarted Plesk MySQL server,
tried to login  to MySQL with user "admin1" and password "PASSWD", recieved "Access denied" error.

8. Set "skip-grant-tables=1" again, logged in to MySQL and updated password for user "admin1"
to match Plesk Admin password:
D:\Program Files\SWsoft\Plesk\admin\bin>"../../mysql/bin/mysql" -uadmin1 -P8306 mysql
mysql> UPDATE user SET Password=PASSWORD('PASSWD') WHERE User='admin1';

9. After that everything began to work fine.