2 messages in com.mysql.lists.win32Re: An Error Was Found -- Details: Ho...
FromSent OnAttachments
pete...@comcast.net18 Nov 2005 10:26 
Daniel da Veiga18 Nov 2005 11:37 
Subject:Re: An Error Was Found -- Details: Host '192.168.3.100' is not allowed to connect to this MySQL server
From:Daniel da Veiga (dani@gmail.com)
Date:11/18/2005 11:37:13 AM
List:com.mysql.lists.win32

Yes, its the way MySQL does authentication, it's based on a 'user'@'host' where you can set masks, specific IPs or hostnames from where the specified user can connect, you can get more info about that checking for the GRANT command syntax in the Manual. To deny connections you simply do not set what you don't want, and thus you exclude any connections from hosts strange to the config you've set.

I've never studied deep the structure of MySQL authentication, it may have more features/enhancements than what I stated above, this is just how far I've gone in configuring it...

On 11/18/05, pete@comcast.net <pete@comcast.net> wrote:

An Error Was Found

Details: Host '192.168.3.100' is not allowed to connect to this MySQL
server

Hi,

Is there such a configuration which permits to allow or disallow to
connect from specific IP addresses to MySQL ?

Peter