Re: An Error Was Found -- Details: Host "192.168.3.100" is not allowed to connect to this MySQL serv

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, peterswiatkowski@comcast.net wr=
ote:
> An Error Was Found
>
> Details: Host '192.168.3.100' is not allowed to connect to this MyS=
QL server
>
>
> Hi,
>
>
> Is there such a configuration which permits to allow or disallow to=
connect from specific IP addresses to MySQL ?
>
> Peter
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org