> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 1:26 AM
> To: michael young; [EMAIL PROTECTED]
> Subject: Re: user privileges question
>
>
> At 18:02 -0400 6/25/03, michael young wrote:
> >Hi,
> >
Hi Paul,
2003年 6月 26日 木曜日 09:55、Paul DuBois さんは書きました:
> At 9:19 +0900 6/26/03, Nils Valentin wrote:
> >Hi Michael,
> >
> >you raised an interesting question.
> >
> >I created a new account (testroot) I gave him all privileges - except the
> >GRANT privilege.
> >
> >GRANT ALL ON *.* TO 'testroot'@'
At 9:19 +0900 6/26/03, Nils Valentin wrote:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+---
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+-
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for users to access
the data in the datbases. New databases will be added in later. I
want to create a user to access these databases with certain rights,
not all rights. Will I have to grant this user