GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' should do the trick: you just specify the IP you want to allow and the netmask to apply to it after the /. You could also use: GRANT SELECT ON db.* TO user@'192.168.1.%' as documented in the manual (http://www.mysql.com/doc/en/GRANT.html). Documentation on the netmask method can be found at http://www.mysql.com/doc/en/Connection_access.html
-Chris On Sun, 2002-08-25 at 14:25, Adam Ryan wrote: > > > Hi, > > I am trying to have a whole class C access the mysql server on the > network. The class C needs to access many different database names. So > adding an entry for each Ip address wouldn't work. Does anyone know how > I can go about this? > > Thanks, > > Adam > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
