MySQL help

[cbolts]

hey there I'm trying to set up coppermine and phpbb, but am lost when it comes to mySQL. any basic info and/or steps to setting this up. any hep appreciated thanks in advance

[MadHatter]

usually this can be done in your cpanel (setting up the database etc), providing you have a cpanel.

[fishfreek]

Go to your hosting control panel and create one or two databases. If you can create two then do that. If you can only create one then thats ok also.

Once the Db's are created then create one db user for each database and assing it a password. Please dont use the same password and please dont use the password you use on your account.

Once this is down write down on a bit of paper for temporary purposes the db names, db usernames and db passwords that coencide with the db's.

Then install phpbb. Where it asks for the database, username and password enter the info you have on the paper for 1 of your databases. When you install coppermine then do the same and enter the data for the other database.

If you can only create one database then you must make sure you assign the database tables different prefixes. For example the default prefix for phpbb is phpbb_. I am not fimular with what the default prefix is for coppermine but you could make it coppermine_ and this way you can have both scripts use the same database and you dont have any risks of having the tables cross contaminated by the other script.