Page 1 of 1

Newbie Question.

Posted: Wed Jun 26, 2002 10:00 am
by Moudy
I'm trying to implant " Poper Webmail " to my site and when I try to grant access on the database to a normal user "
GRANT insert, update, select, delete, alter, drop, create

ON popper.* TO username@localhost IDENTIFIED by 'PWD' "

It says:

Code: Select all

CREATE DATABASE popper

GRANT insert, update, select, delete, alter, drop, create 

ON popper.* TO mraad@localhost IDENTIFIED by 'my password'

MySQL said: 


You have an error in your SQL syntax near 'GRANT insert, update, select, delete, alter, drop, create 

ON popper.* TO mraad' at line 2
anyone knows what am I be doing wrong ?
Thanks

Posted: Wed Jun 26, 2002 10:08 am
by volka
sorry, works just fine on my server. Welcome, user mraad ;)

Posted: Wed Jun 26, 2002 10:17 am
by Moudy
Thanks man.

Here is a screenshot of what I am doing ?
Is there anything wrong ?

and Here is the installation steps taken from popper webpage.
Thanks.

Posted: Thu Jun 27, 2002 3:35 pm
by mikeq
Yep, you need to seperate the first statement Create from the second statement Grant with a semi-colon, or better still execute them seperately.