Quote:
|
Originally Posted by teksonline
mysql is not a firewall, you do not issue block statements...
If you want you can fill me in on what your database does, i think you just have no understanding on administration of mysql, you only have to add the ip's to each database, with its own set of special commands it can run, and not mysql in general anyhow, if you are not doing that, then you are doing it all wrong.
|
Actually, I got this to work no problem, the way I wanted.
Instead of granting each host I want to have access, it was a LOT easier to just keep my wildcard host (192.168.1.%) and then add a row containing the IP I wanted to block, with the same username as the record above, a different password and no privileges.
Thus, anyone trying to connect from that IP with the same username all other servers use, will:
1) Have to find out the password somehow
2) If they do get the password, they will have no privileges on any database tables.