Cron Job to Repair / Optimise All Mysql Databases in Plesk11

[tenoch]

Hi
I was using Plesk 10 before
And this commands were working very well, to repair and optimise all mysql tables

When I logged in SSH, with my main admin password,

username
password

And then typed
su -
And enter my password, this command worked just like this:

mysqlcheck -r -uadmin -pPASSWORD -A
mysqlcheck -o -uadmin -pPASSWORD -A

Since Plesk 11 Upgrade

This don´t work anymore

And I recieved the error:
mysqlcheck: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect

How can I make his work again

I have tried to change
admin
with
my username
or even
root

But nothing seems to work


Any help is appreciated

Thanks

 

[HMoellendorf87]

Hi tenoch,

can you login to your mysql database using mysql -uadmin -p`cat /etc/psa/.psa.shadow`?

Kind regards
Henning

 

[tenoch]

Hi
Sorry for the delay

Yes, after executing this command
mysql -uadmin -p`cat /etc/psa/.psa.shadow`

I recieved a welcome message, and there are not errors

So, what else can I do?
Replace the password with this
`cat /etc/psa/.psa.shadow`
?


Thanks

 

[IgorG]

Why you can't use command like:

# mysqlcheck -r -uadmin -p`cat /etc/psa/.psa.shadow` -A