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