Hi! On Jul 22, Andrew Braithwaite wrote: > Hi All, > > Can I assume by the lack of any responses that the anwser to my question > is no?
The answer is yes: http://dev.mysql.com/doc/mysql/en/Connection_access.html > Cheers, > > Andrew > > -----Original Message----- > From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] > Sent: Tuesday 20 July 2004 16:44 > To: [EMAIL PROTECTED] > Subject: RE: CIDR ranges in MySQL permissions? > > Sorry - a /32 is a single ip - I meant a /27 :) > > A > > -----Original Message----- > From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] > Sent: Tuesday 20 July 2004 16:16 > To: [EMAIL PROTECTED] > Cc: Karl Skidmore > Subject: CIDR ranges in MySQL permissions? > > 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] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]