Topic: MySQL error 1064

[Paul van Dun]

Hello Everyone,

After several succesfull attempts to install phpgroupware, I'm now having a problem I can't solve.
After unpacking the tar file from phpgroupware I create a database named phpgroupware with the command;

mysqladmin create phpgroupware

After this step I need to grant rights to the database user with this command on the prompt of mysql:

mysql> grant all on phpgroupware.* to phpgroupware@localhost indentified by 'password';

MySQL reports the following error:

ERROR 1064 ; You have an error in your SQL syntax near 'indentified by 'password''; at line 1

I've checked and double the command according RequestedDeletion howto and also contacted him regarding the right syntax, has anyone an idea to solve my problem.

Looking forward to your replies.


Best regards,

Paul van Dun
The Netherlands

[guestHH]

Hoi Paul,

It should be 'identified' instead of 'indentified'

Regards,
guestHH

[Paul van Dun]

Hello RequestedDeletion,

Thanks for you "quick" reply, I'm deeply ashamed.

regards,

Paul

[guestHH]

Made the 'same' mistake _many_ times.

"Difficult matters are often solved with simplicity, but simple matters are often solved with difficulty."

from my own 'wisdom' history.

Regards,
guestHH