Newbie Question.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Moudy
Forum Newbie
Posts: 2
Joined: Wed Jun 26, 2002 10:00 am

Newbie Question.

Post 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
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

sorry, works just fine on my server. Welcome, user mraad ;)
Moudy
Forum Newbie
Posts: 2
Joined: Wed Jun 26, 2002 10:00 am

Post 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.
User avatar
mikeq
Forum Regular
Posts: 512
Joined: Fri May 03, 2002 3:33 am
Location: Edinburgh, Scotland

Post 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.
Post Reply