I've got MySQL running as a service on my Windows 2000 box. And I can
work with it using a command window (DOS box). I used the default
install of MySQL and here's what status says:
mysql> status
--------------
mysql Ver 12.21 Distrib 4.0.15, for Win95/Win98
Connection id: 5
Current database:
Current user: ODBC@localhost
SSL: Not in use
Server version: 4.0.15-max-debug
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
My problem is that I can't connect over TCP/IP. Originally I was trying
to connect with MySQLcc but I have dropped back to tring to connect with
Telnet.
Using Telnet I type: open localhost 3306
and I get this garbage:
1
4.0.15-max-debug?{W~5-"aB,?
Connection to host lost.
Press any key to continue...
This tells me that MySQL is indeed listening on port 3306, but that's
about all it tells me.
I installed and configured the ODBC driver for MySQL.
I have not created any new users. Read somewhere that the root user
can't connect over TCP/IP. If this was case I'd expect a more friendly
error message like 'Access denied' or something.
Can anyone tell me how to connect to a local MySQL using TCP/IP on a
Windows 2000 machine?
Thanks for your help.