Sunday, May 20, 2007

mysql-5.0.41-win32 with no install Access denied

When I try 'mysql -u root' I get the same error, except root is in theplace of ODBCERROR 1045 (28000): Access denied for user 'root' @'localhost' (usingpassword: NO)[/snip]In that case, you may have a password set for root. To reset the password,shutdown the mysql server. Then start it from a command line using:[PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tablesThen open another command prompt and run 'mysql -u root' and run thefollowing query:UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost';Then shutdown the server, and restart it normally. You should then be ableto connect with 'mysql -u root'.