• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Cron Job to Repair / Optimise All Mysql Databases in Plesk11

tenoch

New Pleskian
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
 
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
 
Why you can't use command like:

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