MySQL Error

[trinity jecob]

I have MySQL on c:\mysql-5.1.11-beta-win32

From the command prompt after executing the 'mysqld', when I give the command 'mysql' it is giving the following error.

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

What could be the possible reason for it???

Thanks in advance.

[Darlene Burris]

I am brand spanking new at this and may confuse you more than help; but my take on this is that you have to have a user and password defined.

Something like the following:

mysql> GRANT ALL PRIVILEGES ON *.* TO ODBC@localhost
mysql> IDENTIFIED BY 'password' WITH GRANT OPTION;

I like being able to see the post that I am answering, so that I can confirm that I am following the person's query.

Like I said, I am brand spanking new at this and this is the first post on this site. It may take a while for me to get acquainted.

Good Luck to you!!!

[Keith Lynn]

I agree Darlene with your assessment of the problem. Also when replying, there is a icon that looks like two quotes. If you click on that then the user's questions is copied into your response.

Also to the OP, I would recommend going with the more stable version of MySQL since that one is still in beta. There are files associated with the download that specify how to get MySQL running and how to assign a root password.

[Darlene Burris]

Originally posted by Keith Lynn:
I agree Darlene with your assessment of the problem. Also when replying, there is a icon that looks like two quotes. If you click on that then the user's questions is copied into your response.

Also to the OP, I would recommend going with the more stable version of MySQL since that one is still in beta. There are files associated with the download that specify how to get MySQL running and how to assign a root password.

Thanks Keith!!! Maybe I will fit in afterall. Programming does not come easy to me. My degree is in Networking. I took a C++ course ten years ago, but did not like it. In the future I would like to be able to use Java for some network scripting. I just thought that connecting with some other programmers would help give me some insight to what I am in for.

Thanks again for your help and making me feel welcome!
[ December 03, 2006: Message edited by: Darlene Burris ]