(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]
