6 messages in com.mysql.lists.win32RE: Can't connect remotely
FromSent OnAttachments
John Millaway07 Sep 1999 08:15 
Jani Tolonen07 Sep 1999 10:31 
John Millaway07 Sep 1999 11:01 
Jani Tolonen08 Sep 1999 02:52 
John Millaway08 Sep 1999 07:09 
Paul DuBois08 Sep 1999 07:33 
Subject:RE: Can't connect remotely
From:John Millaway (Joh@INTERMEDIAINC.com)
Date:09/07/1999 11:01:05 AM
List:com.mysql.lists.win32

John Millaway writes:

(Ignore previous message with same title.) I'm having difficulty connecting remotely to my database. In fact, while typing this message a found another problem: I can't even connect to my database from the same machine if I specify the host IP address on the command line! I think they are part of the same problem...

This works: mysql --user=me dbname This doesn't: mysql --host=ip_address --user=me dbname (From same machine)

SELECT host, user, password FROM dbname WHERE user='me';

+------+---------------|----------+ | host | user | password | +------+---------------|----------+ | % + me | | +------+---------------|----------+

Thanks, -John

Hello John,

Your problem lays very likely in the privilege system. You need to grant access from different hostnames (or IPs) in the 'mysql' -database. Please see section 'The MySQL access privilege system' from the MySQL manual.

Thanks, but I did know this already. That's why I posted the mysql.user table. As far as I understand (from the manual), I need to put either a '', NULL, or '%' in the host column of the user table in order to grant access to the table from a given ip address. I tried it with all of these to no avail!