Restrict mysql user to certain IP
Date: 06/04/08
(MySQL Communtiy) Keywords: mysql, database, sql
Is there a way to bind mysql users to a specific server IP?
I have two databases running from the same server. I need to ensure that database ABC only allows activity from server IP 123.000.000.111. A second database (XYZ) should only allow activity from server IP 123.000.000.222. Both IPs and databases are on the same box (multiple nics).
If I've explained this poorly please let me know so I can clarify.
Source: http://community.livejournal.com/mysql/128663.html