Hi All,
 
Has anyone had any experience with using IP address ranges in MySQL
permissions?  It would be easy if you had a whole class C for example
because you would be able to do:
 
Grant all privileges on *.* to someuser@'192.87.12.%';

But if you only wanted to give permissions to a CIDR range (e.g. a /32,
192.87.12.1 to 182.87.12.32 etc..) in one go, and used the above method,
it would leave your databases open to connection from others.

Is there any way to do this in a single line (without having an entry
for each IP address) ?

Hope you can help.

Regards,

Andrew

Mysql, query

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to