d2, By the looks of it the client machine you are trying to connect from can resolve the hostname of your 'linuxready' machine perfecetly fine... and your host (according to nmap) is running the MySQL server daemon listening on TCP port 3306. I would suggest the problem lies at the network level.
It may be possible that your distribution by default sets up a firewall that blocks out external MySQL access (this is no an uncommon default). What linux distribution are you running on the host (linuxready)? Also what kind of network lies between the two machines. Are they simply two machines plugging into the same switch/hub? Are they connected via crossover cable? The connection refused message suggests a firewall somewhere between the two machines, I would guess it's most likely running on your host and you don't know it. Lachlan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 July 2004 2:18 AM To: Victor Pendleton Cc: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] ' Subject: Re: i cant connect to mysql from other machine (first: excuse for my english) On Monday 19 July 2004 15:03, Victor Pendleton wrote: > Can you telnet port 3306 on linuxready from the remote machine? nop.. :/ .. i cant do telnet to linuxready 3306 ¡ ----------------------------------------------------- [EMAIL PROTECTED] $ telnet linuxready 3306 Trying 10.205.171.16... telnet: Unable to connect to remote host: Connection refused ----------------------------------------------------- but i have visibility to linuxready.. i can open a ssh session, or ftp session.. i have not configure any firewall. why i cant do telnet to linuxready 3306? i have opened the port: -------------------------------------------------- linuxready root # nmap localhost Starting nmap 3.50 ( http://www.insecure.org/nmap/ ) at 2004-07-19 18:24 CEST Interesting ports on localhost (127.0.0.1): (The 1654 ports scanned but not shown below are in state: closed) PORT STATE SERVICE 22/tcp open ssh 80/tcp open http 3306/tcp open mysql 8009/tcp open ajp13 8080/tcp open http-proxy --------------------------------------------------- thanks d2clon > > -----Original Message----- > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Sent: 7/19/04 4:27 AM > Subject: i cant connect to mysql from other machine > > hello people.. > > i have a curious problem with mysql. > i configure root user acount to enable access from other machines but i > cant > connect.. > > my user table is: > mysql> select * from user; > +-----------+------+------------------+-------------+-------------+----- > --------+-------------+-------------+-----------+-------------+--------- > ------+--------------+-----------+------------+-----------------+------- > -----+------------+ > > | Host | User | Password | Select_priv | Insert_priv | > > Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > > Index_priv | Alter_priv | > +-----------+------+------------------+-------------+-------------+----- > --------+-------------+-------------+-----------+-------------+--------- > ------+--------------+-----------+------------+-----------------+------- > -----+------------+ > > | localhost | root | 1595fd346d9734fe | Y | Y | Y > | > | Y | Y | Y | Y | Y | > > Y > > | Y | Y | Y | Y | Y | > | % | root | 1595fd346d9734fe | Y | Y | Y > | > | Y | Y | Y | Y | Y | > > Y > > | Y | N | Y | Y | Y | > > +-----------+------+------------------+-------------+-------------+----- > --------+-------------+-------------+-----------+-------------+--------- > ------+--------------+-----------+------------+-----------------+------- > -----+------------+ > 2 rows in set (0.00 sec) > > > i execute the flush privileges sentence. > > i try to connect from another machine and this is the error: > $ mysql --host linuxready -uroot -p > Enter password: > ERROR 2003: Can't connect to MySQL server on 'linuxready' (111) > > > Maybe is it possible that I have to configure some attribute in my.cnf? > > thanks in advance > d2clon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
