Feb 182011
Error when trying to upgrade the mysql tables using mysql_upgrade:
root@fooserver:/root# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
The solution is to run mysql with the option --skip-grant-tables and then do the upgrade:
/etc/init.d/mysql stop
/usr/bin/mysqld_safe --skip-grant-tables&
mysql_upgrade
/etc/init.d/mysql stop
/etc/init.d/mysql start
resources
- http://fossplanet.com/f7/mysql_upgrade-fails-access-denied-80196/#post273394
- change mysql root and debian-sys-maint password: http://forums.rimuhosting.com/forums/showthread.php?t=97
VN:F [1.9.22_1171]
[solved] mysql_upgrade failes due to "1045: Access denied", 10.0 out of 10 based on 4 ratings Related Posts:
- No Related Posts