phpbb integration-mySQL error: select command denied to user

[Mamady]

just installed coppermine and trying to integrate with phpbb2... it works great if i dont turn on integration with phpbb2, but when i turn it on, i get the following error in debug mode:

Fatal error :

There was an error while processing a database query.

While executing query "SELECT user_id, username as user_name, user_level FROM `phpBB`.phpbb_users WHERE user_id='0' AND user_password='*'" on 0

mySQL error: select command denied to user: 'myuser@localhost' for table 'phpbb_users'


I have granted all priviledges for that user using the following command:

GRANT select ON mydatabase.* to myuser@'localhost';

I have root priviledges so i can run any commands, but i dont know why it keeps telling me that the user is denied the select command. I would be grateful for any help.

[Mamady]

surely someone must be able to help???