database configuration Help

[JSi]

Need help. Don't know what to put in these two lines for my phpBB Forum.

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server

How do I get the database Name used by the board? How do I know what it is?
How do I get the name of the database Server?

My forum address is www.infectinc.com/forum/
Is "forum" the name of the database used by the board?
Will "infectinc" be the localhost?



Can I get an example of what is used in another forum? That might help.

[CapriSkye]

did you install the board yourself? you should've created a database for phpbb when you installed the forum, and it would be the name you made up. do you have access to mysql database? using phpmyadmin maybe?
and the host is where mysql resides on, usually just localhost.

[JSi]

OK. I got it but I get this 

Fatal error :
There was an error while processing a database query

[Joachim Müller]

temporarily disable integration (edit include/init.inc.php, re-add double slashes you removed before), log in to coppermine using your standalone admin account you created during install, go to coppermine config, enable debug mode (very bottom of screen), log out, (edit include/init.inc.php, remove double slashes you added before), go to coppermine once again in your browser and post the exact error message (the query that actually failed).

Joachim

[JSi]

temporarily disable integration (edit include/init.inc.php, re-add double slashes you removed before), log in to coppermine using your standalone admin account you created during install, go to coppermine config, enable debug mode (very bottom of screen), log out, (edit include/init.inc.php, remove double slashes you added before), go to coppermine once again in your browser and post the exact error message (the query that actually failed).

Ok, this is what I get:

There was an error while processing a database query.
While executing query "SELECT (ug.group_id + 5) as group_id FROM `infect_phpb1`.phpbb_user_group as ug LEFT JOIN `infect_phpb1`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0" on 0
mySQL error: select command denied to user: 'infect_copp1@localhost' for table 'phpbb_user_group'


I use phpMyAdmin. Just in case you need to know that.
Thanx for your help. I hope I can get this fixed soon.

[Joachim Müller]

select command denied to user

insufficient permissions for mySQL user - I guess you're self-hosted

Joachim

[JSi]

select command denied to user

insufficient permissions for mySQL user - I guess you're self-hosted

So now what? How do I fix this?

[Joachim Müller]

go to your mySQL console and set the permissions accordingly - not coppermine related. Check the mySQL manual for details.

Joachim