How can I get this to allow access from any user with the correct passwd to the main mysql server? Any user for the 192.168.1% class with a correct passwd. It seems I can't have a wildcard for the user statement below?
Thanks -----Original Message----- From: Chris Tucker [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 6:58 PM To: Adam Ryan Cc: [EMAIL PROTECTED] Subject: Re: Allowing a whole class C to access mysql server? 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
