mysql access denied for user 'odbc'@'localhost' to database

Question

I installed MySql5.5 and set password during installation but when I try to use mysql from windows command prompt, I have get the error:

access denied for user 'odbc'@'localhost' to database password = 'YES'

I would like to change it back into "root@localhost" as well as to reset the password but I can't log in mysql.

How do I login to mysql with root?

Answer 1

You're trying to use the mysql interactive shell? You can specify usernames at the command line:

c:\> mysql -u root -p

where

-u = specify username
-p = prompt for password

Answer 2

I fixed this by implementing a little hacky solution. Downloaded hxd (hex editor) and searched for 'ODBC' (there should only be one match) and just changed it to 'root'.