Is "linuxready" an address visible from your other machine? Could you need a hosts file entry? Could you need to add that address to your internal DNS server?
Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 07/19/2004 05:27:02 AM: > 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] >