The server that has the mysql DB, has a control panel adding and removing new mysql databases and mysql users all of the time. Is there any possible way to have one global grant table for all of the users coming from 192.168.1.%? I believe I attempted this a while ago, but I used an INSERT command on the host table. Not sure if that was the safest thing todo, actually it wasn't.
So all valid dbs, coming from inside the network of 192.168.1.% should be allowed access to the main 192.168.1.4 mysql server. How would I just have it so ANY user can get into the server without adding a new grant for every user? Adam -----Original Message----- From: Lucas Saud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 9:45 AM To: Adam Ryan Cc: [EMAIL PROTECTED] Subject: RE: Allowing a whole class C to access mysql server? Importance: High hi, > 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? You could use: GRANT ALL ON *.* TO user@'192.168.1.%' hum, try to look at manual: http://www.mysql.com/doc/en/GRANT.html cheers, =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Lucas Marinho Saud | | E-Mail: lucas.marinho AT uol.com.br | | Phone: (+55) 21 62 282 6084 | | Location: Goiania, GO - Brazil | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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
