• MySQL知识库 :: odbc
  • Why is my username reported as ODBC when I am connecting?

  • Discussion

    When connecting to MySQL you may encounter the following error message:

    ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
    

    This message can be encountered when connecting to a Windows based server regardless of whether you are connecting via ODBC or not.

    Solution

    The ODBC username is a default username used when connecting to a MySQL server on Windows. If you receive an access denied error for an ODBC user, it is because you did not explicitly specify a username when connecting. To correct this, specify a username:

    mysql -u username
    
    mysql --user=username