Re: User and permissions/grants - HELP!

2003-10-28 Thread Nitin
;; <[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

Re: User and permissions/grants - HELP!

2003-10-28 Thread Patrik Fimml
> 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

Re: User and permissions/grants - HELP!

2003-10-27 Thread Nitin
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

Re: User and permissions/grants - HELP!

2003-10-27 Thread Victoria Reznichenko
"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

User and permissions/grants - HELP!

2003-10-25 Thread C. Reeve
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