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]
