Database - "If you already have a database...."

[Lady18wheels]

If this has already been covered, I apologize.  I can't find it.  I'm confused about the database installation and configuration.

I have a phpBB test board - it's database is named ********_phpb3.  (I also have a phpb1 and phpb2)
The username for phpb3's database is ********_*****
The password for this username is *********

The readme file that came with the cpg1.4 download says:

You need to create a MySQL database. Using your website Control Panel or a tool like phpMyAdmin, create a MySQL database. Write down the database name, the username and password – you'll need it to successfully install Coppermine. If you already have a database you're using for a BBS or something else, that'll work just as well. You can use that database for Coppermine, too. If you have a BBS and plan to connect it to Coppermine install, you'll need to share the database anyway.

After uploading all the files, and changing the permissions on the appropriate files, I tried to run cpg140/install.php using the phpBB database values for the "Your MySQL configuration".  It didn't work.  Should it have?

I appreciate your time. 

[Nibbler]

What do you mean by "It didn't work" ?

[Tranz]

It should have worked if you used the same mysql values, as long as the prefix is different. However, you would need to say what went wrong and any error messages you see.

[Lady18wheels]

This is the error msg:

Could not create a mySQL connection, please check the SQL values entered
MySQL error was : Access denied for user: '********_***** @localhost' (Using password: YES)

[Lady18wheels]

... as long as the prefix is different. ....

The prefixes for my phpBB tables are phpbb_
and I assumed that the "MySQL table prefix" default (which is cpg140_) on the cpg140/install.php meant that the installer would do whatever it does to create the table in the phpb3 database using the prefix cpg_140.  Is this, in fact, how it's supposed to work?

Maybe I should say that I also have a copp1 database - fantasico install of v1.3.4, but it isn't bridged.

[Lady18wheels]

Since there were no other replies to this, I created a seperate database and will try to bridge later.

[Joachim Müller]

coppermine doesn't create a database. Use the same database you use for your bbs. Keep the default prefix. Details: http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#install_screen_start

[Satyr]

It's much better to install the tables in the same database as the forum where you want coppermine have beeing bridged.
Depending on serverconfiguration it is possible that you can only access the database via localhost.
That's why it's necessary that both programs have the same database/same mysqlserver.

[Lady18wheels]

Thanks.

I was able to install on my test board this time - no error messages    Not sure why I got
Could not create a MySQL connection, please check the SQL values entered
MySQL error was : Access denied for user: '********_***** @localhost' (Using password: YES)
on the first go 'round.  Maybe something just hadn't had time to update in MySQL?  I guess it doesn't matter now, because the coppermine tables are, in fact, in the same database as my test phpb3.  

In general, if the tables aren't installed in the same database as a phpbb, is a bridge even possible between two seperate databases?
I think this is what Satyr is saying?  I'm so new at all this ....