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

[tage jørgensen]

Hi

I had that problem that I could not connect to the DB, allways got that error message.

Then I found a website, where the solution were.

The Site: http://forge.mysql.com/wiki/Error2003-CantConnectToMySQLServer

Then I did this:

mysql> \s;
--------------
mysql Ver 14.14 Distrib 5.1.23-rc, for Win32 (ia32)

Connection id: 45
Current database:
Current user: ODBC@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.23-rc-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 12 hours 7 min 17 sec

Threads: 1 Questions: 625 Slow queries: 0 Opens: 32 Flush tables: 1 Open ta
bles: 0 Queries per second avg: 0.14
--------------

ERROR:
No query specified

And found out that even I was typing i.e. 'root' in the MySql configuration, it enden up making the user 'odbc'.

So when I accepted not to be able to specify my own user and started useing 'odbc',all was working