;; <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 6:23 PM
Subject: Re: User and permissions/grants - HELP!
>
> > i dont think there's any privilege called "ALL PRIVILEGES". You need to
say
> > just "ALL", like:
> >
> > GRANT ALL O
> i dont think there's any privilege called "ALL PRIVILEGES". You need to say
> just "ALL", like:
>
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> '12345678' WITH GRANT OPTION;
> GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH
> GRANT OPTION;
Maybe you should read the docum
WITH
GRANT OPTION;
Enjoy
Nitin
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 7:43 PM
Subject: Re: User and permissions/grants - HELP!
> "C. Reeve" <[EMAIL PROTECTED]> wr
"C. Reeve" <[EMAIL PROTECTED]> wrote:
>
> I just installed MySQL version 4 and as usual, trying to set up users
> and grant permissions is a nightmare.
> I followed the instructions in the MySQL manual and granted permissions
> to a user, like below:
>
> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROT
Hi,
I just installed MySQL version 4 and as usual, trying to set up users
and grant permissions is a nightmare.
I followed the instructions in the MySQL manual and granted permissions
to a user, like below:
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT OPTIO