>> I'm trying to run mysql_upgrade but I get: >> >> # 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 >> >> I've also tried specifying my root password with --password and also >> specifying -u mysql but it still fails with error 1045. My >> /etc/passwd file looks like there is no password for user mysql. What >> else should I try? > > You should use the password for the _MySQL_ root user, which is _not_ stored > in /etc/passwd, but within MySQL. > > / Carsten
Thanks everyone. I got mysqld to start with --skip-grant-tables by adding skip-grant-tables to /etc/mysql/my.cnf and restarting mysql. mysql_upgrade ran without a problem. - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org