• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Resolved mysql_update failed

regisg

Regular Pleskian
Hello,

I'm logged in as admin and when I use this SQL command "mysql_upgrade -uroot -p --force
Enter password:"

I've got this error

"Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed"

What can I do?

Thank you for kindly replying to me :)
 
Hi regisg,

pls. be informed, that there is NO root account, when you don't add one. Plesk itself uses the user "admin" as root - replacement.
You command should be:

Code:
mysql_upgrade -u admin -p`cat /etc/psa/.psa.shadow`
OR
Code:
mysql_upgrade -u admin -p`cat /etc/psa/.psa.shadow` --force
 
Back
Top