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

[SKB]

Hi,
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
O)

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).

Regards
SKB

[Aggro]

SKB wrote:

Hi,
I am absolutely new to this area. I am getting the following difficulty
:
Access denied for user 'ODBC'@'localhost' (using password: NO)

Here are some things to test and try:
http://dev.mysql.com/doc/refman/5.0/...on-errors.html

[Bill Karwin]

"SKB" <bo********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Access denied for user 'ODBC'@'localhost' (using password: NO) .. . . (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).

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:
http://dev.mysql.com/doc/refman/5.0/...onnecting.html

And read the section of the docs starting at the link below, to learn more
than you ever thought possible about users and privileges:
http://dev.mysql.com/doc/refman/5.0/...ge-system.html

Regards,
Bill K.