Help with Grant Permission

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Kingo
Forum Contributor
Posts: 146
Joined: Thu Jun 03, 2004 9:38 am

Help with Grant Permission

Post 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!
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

Have you flushed privileges? Also, this should be in the database forum, not here. :)
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply