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;
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.
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.