Resolved Mysql password root

[Nicola]

Hi,
how can I recover the mysql password root?

Thanks in advance

 

[IgorG]

There is no root mysql account on Plesk server. Use admin account instead of root.

 

[Nicola]

ok, with the same password of plesk?

I need to prepare a command that optimize all database (mysqlcheck -u admin -pxxxxx --optimize --all-databases) but I get this error "mysqlcheck: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect"

 

[Nicola]

Solved,

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --optimize --all-databases