If you don't want to do any username checking (just checking a password) you can use a blank username. Easiest way to do this is probably something along the lines of: GRANT SELECT ON db.* TO temp@'192.168.1.0/255.255.255.0' IDENTIFIED BY 'mypass'; UPDATE mysql.user SET user = '' WHERE user ='temp' AND host = '192.168.1.0/255.255.255.0'; FLUSH PRIVILEGES;
Then anyone coming from the 192.168.1.* C-class will be able to access by just specifying a password. You may have to be a little careful that using a blank username doesn't kill any other perms you have set up: read the docs about the order in which things are matched to determine appropriate user perms. -Chris On Mon, 2002-08-26 at 16:15, Adam Ryan wrote: > > 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 > > > --------------------------------------------------------------------- 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
