create a user for app admin

------=_NextPart_000_00BF_01CAB6B9.3A505A70
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable

Is there a way to create a user that has full control over a specified =
database but cannot access any other database at all?
that user cannot delete the specified database, cannot create/delete =
other database, but can do everything within the specified database?

Thanks for any help.
------=_NextPart_000_00BF_01CAB6B9.3A505A70--

Re: create a user for app admin

--005045016abd2c979b048082644c
Content-Type: text/plain; charset=ISO-8859-1

Yes, there is.

Go and have a look at the documenation for the GRANT statement, and
understand what you're doing before executing some command line some random
person gives you.


2010/2/26 Elim PDT

> Is there a way to create a user that has full control over a specified
> database but cannot access any other database at all?
> that user cannot delete the specified database, cannot create/delete other
> database, but can do everything within the specified database?
>
> Thanks for any help.




--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--005045016abd2c979b048082644c--

Re: create a user for app admin

At 08:56 AM 2/26/2010, Elim PDT wrote:
>Is there a way to create a user that has full control over a specified
>database but cannot access any other database at all?
>that user cannot delete the specified database, cannot create/delete other
>database, but can do everything within the specified database?
>
>Thanks for any help.

After reading the manual on Grant, download SqlYog community edition. It
has a GUI that sets up user rights.

http://code.google.com/p/sqlyog/

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org