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; 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]> 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 PROTECTED] IDENTIFIED BY > > '12345678' WITH GRANT OPTION; > > GRANT ALL PRIVILEGES ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH > > GRANT OPTION; > > > > I can log in with this user, but I can't do anything (i.e. create a > > database). There is also no mysql database (there is though if I log in > > as root). > > > > Could you connect to the MySQL server? What exactly error messages did you get? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]