May 22nd, 2010
How can I change/repair my Admin account if the password in Plesk?
How can I change/repair my Admin account if the password in Plesk?
login.php3: Unable to connect to database: Permission denied
ERROR 1045: Access denied for user: ‘admin@localhost’ (Using password: YES)
First try to restart Parallels Plesk Panel:
Check that the /etc/psa/.psa.shadow file has valid permissions. The right permissions would be
-rw——- 1 psaadm psaadm 5 Feb 26 11:22 /etc/psa/.psa.shadow
In case you have any other permission, you should change it using the following command:
# chmod 600 /etc/psa/.psa.shadow
Check that Mysql server is running and working properly using the “ps ax | grep mysql” command. For example:
To check that Mysql server is running fine, try to access to the mysql console. For example:
In the newest versions of Parallels Plesk Panel, the password can be restored using the “ch_admin_passwd” utility.
To change the password, use a command like the following one:
Load MySQL with ’skip-grant-tables’ option, adding skip-grant-tables to the [mysqld] section of /etc/my.cnf file
Restart MySQL with the following command prompt:
Add the new password to the /etc/psa/.psa.shadow file.
Repair the password using the following command prompt:
Delete skip-grant-tables option from /etc/my.cnf
Restart MySQL.
Reference: http://parallels.com/