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
