MySQL Server Forum - Allowing multiple hosts...

Author

Allowing multiple hosts...

wink martindale

2005-08-17, 8:23 pm

Hello All,

I am creating a vb.net app that conncects to mysql with the corelabs
provider. This app will be deployed on our intranet. My question is
this: Do I have to create different user for each host? For example,
my ip range is 192.168.1.*. Can I create one user with this host
"Range" and allow them to connect. If so, how do I accomplish this.

Thanks in Advance,

Daniel

Aggro

2005-08-17, 8:23 pm

wink martindale wrote:

> I am creating a vb.net app that conncects to mysql with the corelabs
> provider. This app will be deployed on our intranet. My question is
> this: Do I have to create different user for each host? For example,
> my ip range is 192.168.1.*. Can I create one user with this host
> "Range" and allow them to connect. If so, how do I accomplish this.

GRANT ALL ON databasename.* TO username@'192.168.1.%' identified by
'password';

wink martindale

2005-08-17, 8:23 pm

On Wed, 17 Aug 2005 19:55:39 GMT, Aggro <spammerdream@yahoo.com>
wrote:

>wink martindale wrote:
>
>
>GRANT ALL ON databasename.* TO username@'192.168.1.%' identified by
>'password';

Ran a quick test, and it worked great. Thanks very much for the
help!!!

Wink

Bill Karwin

2005-08-17, 8:23 pm

wink martindale wrote:
> Hello All,
>
> I am creating a vb.net app that conncects to mysql with the corelabs
> provider. This app will be deployed on our intranet. My question is
> this: Do I have to create different user for each host? For example,
> my ip range is 192.168.1.*. Can I create one user with this host
> "Range" and allow them to connect. If so, how do I accomplish this.

mysql> GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'192.168.1.%'
IDENTIFIED BY 'password';

I can't find how to do an equivalent thing in the MySQL Administrator
GUI tool.

Regards,
Bill K.

Sponsored Links