GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Varius · 05-31-2005, 10:19 AM

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 an internal network to be allowed to connect except for one.

I currently use 192.168.1.% in mysql.user table so that all hosts are allowed.

Is there a way to leave that and disallow just one host? Or must I remove that line and enter every single IP on my network one by one (except ofcourse the one I don't want to connect) ??

Thanks

05-31-2005, 10:19 AM
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	MySQL: How to Block specific hosts 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 an internal network to be allowed to connect except for one. I currently use 192.168.1.% in mysql.user table so that all hosts are allowed. Is there a way to leave that and disallow just one host? Or must I remove that line and enter every single IP on my network one by one (except ofcourse the one I don't want to connect) ?? Thanks __________________ Skype variuscr - Email varius AT gmail