How to block hosts form connecting in MySQL?

[kid_c]

Hi all,

I was wondering if there was any way to block specific IPs from connecting to MySQL?

for example, I want all machines on my internal network to be allowed to connect except for one.

I use 192.168.1.% in mysql.user table and it works fine.

Is there a way to leave that and disallow just one host? Or must I remove that line and enter evry other IP on my network one by one ??

Thanks

[bastien]

Or must I remove that line and enter evry other IP on my network one by one ??

I think this is what might need to be done

[id10t]

Probably easier to just have mysql accept connections from everyone and use a firewall (iptables) to control the access...