Root Password Error on upgrade

[tnats@]

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

 

[helix]

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.

 

[tnats@]

Thanks Helix, I will try today. I thought this thread was dead. Thanks again!

 

[tnats@]

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.