Can't connect to database...

[adaytay]

Hi all,

Following on from my other recent post, I've hit another problem after amending the config file.

I get the following error:

Code Select Expand

While executing query "SELECT user_id, username as user_name, user_level FROM `forum`.phpbb_users WHERE user_id='3' AND user_password='4fb9b3f605b60767ad9ce2c0e6288094' AND user_active='1'" on 0

mySQL error: SELECT command denied to user: 'mcknight_mcknigh@localhost' for table 'phpbb_users'

I've checked in phpMyAdmin and user 3 has definitely got the correct password, so no problems there, I'm just a little confuddled as to why I've got no access to run the file, I've checked the permissions and the user mcknight@mcknigh@localhost has full access to the database?

Any ideas?  PLEASE tell me I don't have to reinstall....

[Joachim Müller]

The mySQL user doesn't have the necesarry permissions. If you have something like cpanel, you should modify the permissions for your mySQL user there. The user needs CREATE TABLE, ALTER, INSERT, UPDATE, SELECT, DELETE permissions. If your webhost doesn't provide you with an interface to change the permissions for the mySQL user, ask them to change this for you.

[adaytay]

Thanks GauGau,

I've double-checked and triple-checked the settings, (I have cPanel), and the user has all permissions.  As mentioned in a previous post, CPG is bridged via phpBB, and the phpBB install on the same db works with no problems whatsoever?

Anything else it could be?

Cheers,

Ad

[adaytay]

I missed the bridge file... database name was incorrect.

D'oh!!

Thanks for helping anyway