1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Root Password Error on upgrade

Discussion in 'Plesk for Linux - 8.x and Older' started by tnats@, Dec 22, 2006.

  1. tnats@

    tnats@ Guest

    0
     
    Anyone know what password it's trying to use?

    I had thought the root account in mysql was disabled in Plesk. So, why would the upgrade be trying to login as root?

    -bash-3.00# more /tmp/psa-predb_8.1.0_centos4.2.build81061213.17_installing.log
    START psa-predb-8.1.0-centos4.2.build81061213.17 installing AT Fri Dec 22 10:41:06 MST 2006
    Trying to flush local mysql passwd... ERROR 1045 (28000): Access denied for user 'root'@'loc
    alhost' (using password: YES)
    Mysql exited with non-zero status 256 at -e line 27.
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    ERROR while trying to execute SQL query, the query was: update mysql.user set Password=PASSWO
    RD('') where User='root' and Host='localhost';flush privileges;

    Aborting...

    STOP psa-predb-8.1.0-centos4.2.build81061213.17 installing AT Fri Dec 22 10:41:06 MST 2006
    START psa-predb-8.1.0-centos4.2.build81061213.17 installing AT Fri Dec 22 10:55:05 MST 2006
    Trying to flush local mysql passwd... ERROR 1045 (28000): Access denied for user 'root'@'loc
    alhost' (using password: YES)
    Mysql exited with non-zero status 256 at -e line 27.
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    ERROR while trying to execute SQL query, the query was: update mysql.user set Password=PASSWO
    RD('') where User='root' and Host='localhost';flush privileges;

    Aborting...

    STOP psa-predb-8.1.0-centos4.2.build81061213.17 installing AT Fri Dec 22 10:55:05 MST 2006
     
  2. helix

    helix Guest

    0
     
    hi there

    i had the same problem. after a few hours of work i found the solution on the website of swsoft:

    please refer to the following link:
    http://www.swsoft.com/en/products/plesk7/faq/installation_upgrade/
    (Plesk installation fails with the error below)

    so, after the additional entry 'skip-grant-tables' and a following reboot of the server (also only reboot the mysql-server schould be engough)the upgrade from 8.0.1 to 8.1.0 worked well.
     
  3. tnats@

    tnats@ Guest

    0
     
    Thanks Helix, I will try today. I thought this thread was dead. Thanks again!
     
  4. tnats@

    tnats@ Guest

    0
     
    I tried what they suggested but it didn't work. I ended up just restarting mysql with the option skip-grant-tables included in the my.cnf.

    From there, I did the upgrade and it went fine, then I commented the skip-grant-tables line out and restarted mysql and everything is happy.
     
Loading...