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.
surely someone must be able to help???