If you need tips & tricks, here they are...

Joomla! AddThis


Fix wrong password in registry

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

Add comment

Security code

Please consider supporting our efforts.

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.