By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Feb 4 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Feb 4 '06 #2

P: n/a
"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.
Feb 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.