(excuse for my english) thx for your interest Lachan..
the problem was the attribute bind_address at the my.cnf :) thanks d2clon On Tuesday 20 July 2004 02:59, Lachlan Mulcahy wrote: > 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]
