I cannot access to plesk 11.5.3

[LucaDefra]

Hi,
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142)
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log I note:
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'
How can I resolve this?
kind regards

 

[InderS]

Hello,

Please check : http://kb.parallels.com/en/116916

 

[LucaDefra]

Hello,

Please check : http://kb.parallels.com/en/116916

Many thanks for your replay,
but with mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql I obtain:
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'

 

[LucaDefra]

same error

Thanks for your replay,
but with mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql I obtain the same
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'

 

[LucaDefra]

Many thanks InderS,
but I cannot access again:
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'

 

[LucaDefra]

Many thanks for your replay,
but with mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql I obtain:
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'

Can I put --skyp-grant-tables to my.cnf to avoid permission in tables and reset admin password?
Do you know a good way to do this?

 

[InderS]

Hello,

You can check your admin password through following command

/usr/local/psa/bin/admin --show-password

And if you want to change the admin password try following

/usr/local/psa/bin//init_conf -u -passwd <new_password>

 

[LucaDefra]

Hello,

You can check your admin password through following command

/usr/local/psa/bin/admin --show-password

And if you want to change the admin password try following

/usr/local/psa/bin//init_conf -u -passwd <new_password>

Hi, many thanks but:

with /usr/local/psa/bin/admin --show-password I obtain
2013-11-12T16:43:37+01:00 ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa'; trace: #0 /usr/local/psa/admin/plib/functions.php(2808): isPpaKeyRequired()

with second comand the same result.

kind regards

 

[IgorG]

There is really something wrong with mysql authentication. Contact Parallels Support Team if you can't reset it by yourself.

 

[SergeNjabs]

Hi, many thanks but:

with /usr/local/psa/bin/admin --show-password I obtain
2013-11-12T16:43:37+01:00 ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa'; trace: #0 /usr/local/psa/admin/plib/functions.php(2808): isPpaKeyRequired()

with second comand the same result.

kind regards

Hi I am new to Plesk and have the same problem? Any ideas anyone?

 

[IgorG]

Hi I am new to Plesk and have the same problem? Any ideas anyone?

Have you tried mentioned KB article?