Demirchyan Oganes-AOD098 writes: > Hello everyone, > > I'm trying to grant rights to several user accessing my database. > Right now I'm using their individual IP addresses to grant them privileges. Which >works fine. > This way I have to assign user name and password to each and everyone of them. > > What I want is to enable everyone within my network to connect to my DB. For that I >need a valid host name. > I have tried %, which supposed to let everyone in, but no luck. I also tried >something like 10.45.*.* or 10.45.%.% > but no luck. > > > I'm stuck. What else can I do? > > Regards, > > Oganes Demirchyan > Motorola Life Science > 757 S.Raymond > Pasadena, CA 91105 > Tel: 626-584-5900 > email: [EMAIL PROTECTED] >
Try this: grant select on *.* to user@"%" identified by "password" -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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