Can you telnet port 3306 on linuxready from the remote machine? -----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]
