Help with MySQL GRANT command

[NoBullMan]

Hi all,
I posted a similar question a while ago but had no replies,so I am trying again.
My orginal question was with PHP code not allowing access to DB ,using pconnect (under the forum message heading "Access Denied")
I found that the problem was with the GRANT command when I had:

GRANT SELECT , INSERT , UPDATE , DELETE ON sassisc.* TO sassisc@localhost IDENTIFIED BY 'dodge3'

It came back with an error message:

SQL-query :

GRANT SELECT , INSERT , UPDATE , DELETE ON sassisc. * TO sassisc@localhostIDENTIFIEDBY 'dodge3'

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY 'dodge3'' at line 1

For some reason, the words "localhost", "identified" and "by" were stuck to each other.
I removed the "identified by 'dodge3'" and it worked fine.

Does anyone know why this is the case? Is it OK to grant these privileges without a password required?

Thanks a lot.

[bastien]

its the @ thats throwing it

adding a user

see granting priviledges here

[NoBullMan]

I am sorry, being a newbie, I don't see the difference between my GRANT stmt and the one in the example you pointed me to.

In the example it has:
mysql> GRANT ALL PRIVILEGES ON . TO monty@localhost
-> IDENTIFIED BY 'some_pass'

I have:
GRANT SELECT , INSERT , UPDATE , DELETE ON sassisc.* TO sassisc@localhost IDENTIFIED BY 'dodge3'