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]
> 

Reply via email to