I believe you shoul comment out the bind_address option on config file...

Hope this helps,

      Giulio

Il giorno 19/lug/04, alle 11:27, [EMAIL PROTECTED] ha scritto:

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]




Cantoberon Multimedia srl
http://www.cantoberon.it
Tel. 06 39737052


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to