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]