Page 1 of 1

Help with Grant Permission

Posted: Thu Jun 03, 2004 12:57 pm
by Kingo
Hello,
I'm trying to insert data from a form to a table in the database.
I get the following error.

Could not execute mysql query !insert command denied to user: 'abc@localhost' for table 'contact'

I tried to grant permissions to the database and the table using the following.

mysql> grant all on php_proj.* to abc@localhost identified by '123';
ERROR 1044: Access denied for user: '@localhost' to database 'php_proj'

Can any one help me out!

Posted: Thu Jun 03, 2004 2:26 pm
by pickle
Have you flushed privileges? Also, this should be in the database forum, not here. :)