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]

Reply via email to