Access Denied Error

[bradcom]

Hello, I've just installed MySQL on a windows 2000 machine, and I've been following the documentation manual that came with the package (mysql-4.0.20d-win.zip), however I'm running into an access denied error.
I've installed the server, which seemed to complete sucessfully. I then followed the steps in the manual (2.2.1.5 Starting the Server for the First Time)to start the server:
C:\mysql\bin\mysqld --console
That seemed to work also, however when I go to the next step (2.4.1 Windows Post-Installation Procedures), I try:
C:\mysql\bin\mysqlshow
and get:
C:\mysql\bin\mysqlshow: Access denied for user: 'ODBC@localhost' (Using password
: NO)
I've looked through the manual and have found that it is Error 1045 (ER_ACCESS_DENIED_ERROR 1045), however I don't know what to do next.
I also tried logging into the server as root using:
C:\mysql\bin>mysql -u root
and received:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
I've found a bunch of information when doing searches to figure this out, however nothing that is helping me fix the problem. Please help if you can ... thank you.

 

[jpor]

Have you looked at your ODBC connection and see what the connections are set for? And also see about setting a test password. Sounds to me that the ODBC won't connect at that level without a password. Seemingly you are connecting with a very high connection of 'root'.

To check ODBC do the following:

1st make sure you have 'Administration tools' showing in start->programs. If not right click the status bar choose properties and go to customise and check the box next to Administration tools. Then go into administration tools and choose 'Data Sources (ODBC). And see if there is a mysql connection or the like. Then go from there.




( "To become Wise, first you must ask Questions&quot