Hi,

Try this request:

grant all on db.bsd
to shadowgrl@'%'
identified by "testing123"
with grant option;

Regards,
Sébastien

> -----Message d'origine-----
> De : Michael Sharp [mailto:[EMAIL PROTECTED]]
> Envoyé : samedi 9 mars 2002 13:08
> À : [EMAIL PROTECTED]
> Objet : adding a user to a database
>
>
> I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL.
>
> I created the database " bsd " as root. I need a remote user, connecting
> from any IP and logging in with " shadowgrl " and giving the password "
> testing123 " to have full access to the bsd database only.
>
> After making the bsd database, I did this:
>
> grant all on db.bsd
> to shadowgrl@
> identified by "testing123"
> with grant option;
>
> I know the last option is dangerous, but I trust this user fully, and the
> server is firewalled to only allow her network in.
>
> However, when connecting remotely, shadowgrl is getting error: user has no
> access to server
>
> What am I overlooking?
>
> Michael
>
>


---------------------------------------------------------------------
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

Reply via email to