problem while connecting....

[Leonard]

Hi all.
I have two linux boxes running fedora core 4 on my home network, with mysqld up and running on "hostname_1". I want to log into the mysql server on the desktop using a mysql client on my laptop ("hostname_2").

[user@hostname_1]$ mysqladmin ping -h hostname_1
mysqld is alive

[user@hostname_2]$ mysqladmin ping -h hostname_1
mysqladmin: connect to server at 'hostname_1' failed
error: 'Lost connection to MySQL server during query'

but then if I netstat it....
[user@hostname_1]$ netstat -ltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
....... ------- ......
tcp 0 0 *:mysql *:* LISTEN -
....... ------- ......

and nmap gives me:
[root@hostname_1]$ nmap -sT -O hostname_1
PORT STATE SERVICE
..... ------ .......
3306/tcp ope -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

See if your my.cnf file sould be in /etc/ or /etc/mysql .
find the bind-address option if it says 127.0.0.1 or localhost this might be your problem,
change it to your hostname_1 ip address -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --