Unable to connect to RH8 MySQL box from Windows

[Pleiades]

I have MySQL installed on RH8, and am able to connect locally to the server, but cannot connect from my Windows box using MySQLCC, or MySQLGui. I get a "Lost connection to MySQL server during query" message on both clients. Port 3306 is open, I have an entry in the user table with the Host set to '%', but no joy.

If I attempt to Telnet to port 3306 from the Windows machine, I get "Connection to host lost" immediately, doing the same from the linux box gives me:
[pre]
[davidn@tron etc]$ telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
(
3.23.52H.O$bBbI,Connection closed by foreign host.
[davidn@tron etc]$
[/pre]
Anyone have any clues why I cannot connect remotely?

Here is copy of /etc/my.cnf :
[pre][mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[/pre]

[Schotty]

hmmm ... is your firewall AND /etc/hosts.allow AND /etc/hosts.deny set appropriately?

like is it just MySQL that doesnt work right or SSH/Telnet ?

[Pleiades]

Schotty - I am able to connect via SSH and Telnet with no problems. The box also does Samba file sharing, DNS, DHCP, SMTP, POP3 and HTTP, all trouble free.

I'm guessing that there is some setting somewhere that I have to define to allow the client to connect to the server, but I've never had this sort of trouble before.

I know I would be able to use phpMyAdmin to do this, but the MySQLcc interface is so much nicer (and a hell of a lot easier to use).

[Schotty]

Look up the command grant. You will need to execute a grant priveledges from all users and for each machine (wildcards do work to make life simpler or possibly insecure and shitty ;D ).

[Pleiades]

I had already created a user with the command:
[pre]INSERT INTO mysql.user SETHost = '%',
User = 'monty',

Password = PASSWORD( '*******' ) ,
Select_priv = 'Y',
Insert_priv = 'Y',
Update_priv = 'Y',
Delete_priv = 'Y',
Create_priv = 'Y',
Drop_priv = 'Y',
Reload_priv = 'Y',
Shutdown_priv = 'Y',
Process_priv = 'Y',
File_priv = 'Y',
Grant_priv = 'Y',
References_priv = 'Y',
Index_priv = 'Y',
Alter_priv = 'Y' [/pre]
to no avail.

I am still nowhere with this, and would really like to use MySQLCC over phpmyadmin.

I used to use MySQLGui with MySQL on SuSE 8.0, so I am guessing that there is something on RH8 that requires setting. I should point out that I have no firewall on either the database server or the Windows client machine.