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

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I am absolutely new to this area. I am getting the following difficulty
Access denied for user 'ODBC'@'localhost' (using password: NO)
when I try the mysql command from within the C:\Program
Files\MySQL\MySQL Server 5.0\bin on the command window.
Please note that the MySQL is runnging as I have tried the command NET
START MySQL and it gives the following output:
The requested service has already been started.
More help is available by typing NET HELPMSG 2182.

However when I try the command mysqladmin ping, it gives error as:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'

Thereafter giving mySQL at the command prompt gives the error:
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using
password: N

Since I am absolutely naive to this area...I am not getting any clues
as to what needs to be done...Any pointers will be a lot help!!

NOTE that I have first installed the myODBC driver
(mysql-connector-odbc-3.51.12-win32_setup.exe) and on top of it I have
installed the MySQL mysql-5.0.18-win32_Setup.exe file and without any
root passwd(that is I have toggled off the root passwd box).


Re: Access denied for user 'ODBC'@'localhost' (using password: NO)

SKB wrote:
Quoted text here. Click to load it

Here are some things to test and try:

Re: Access denied for user 'ODBC'@'localhost' (using password: NO)

Quoted text here. Click to load it
. . .
Quoted text here. Click to load it

Try running the mysql command with the following option:

    C:> mysql -u root

This specifies the "root" MySQL user when you connect.

Because you didn't specify any user, it defaulted to an "anonymous"
(unnamed) user.  On Windows, the username is set to "ODBC" for some reason
unknown to me (one would think it'd use the account name of the current
Windows user, as long as you were connecting from Windows NT/2000/XP).

Read this page (part of the tutorial) about connecting:

And read the section of the docs starting at the link below, to learn more
than you ever thought possible about users and privileges:

Bill K.

Site Timeline