I took a backup.. But now I cant restore it

[castion]

I recently changed servers and took at complete backup of both site and DB..

I have now restored the DB and uploaded the files on the new server.
The trouble is that I originally installed through fantastico, so I dont know the password for the Database..

Is there any way I can change the DB user and DB name in a config file somewhere?

[Nibbler]

The config file is include/config.inc.php.

Note that the username and password is not in the backup, it is part of the configuration of the new server. Make a new user and put the details in config.inc.php

[castion]

Thank you very much for your answer..

But for some reason I keep getting the same message:
--------------------------

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'den_copp1'@'localhost' (using password: YES)

------------------------------------

den_copp1 is the new user I created..

And I am pretty sure that all the info is correct in the config.inc.php file..
You wouldent have a suggestion to what might be going wrong here?

[François Keller]

re check the config.inc.php and be sure to overwrite the old file.

so I dont know the password for the Database..

but you must have this information to complete the database connection info

[Nibbler]

Ask your host to verify the details for you.

[castion]

Hmm... But do I need the original password for the DB ?

[Nibbler]

No - see my explanation above.

[jackd]

Thank you very much for your answer..

But for some reason I keep getting the same message:
--------------------------

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'den_copp1'@'localhost' (using password: YES)

------------------------------------

den_copp1 is the new user I created..

And I am pretty sure that all the info is correct in the config.inc.php file..
You wouldent have a suggestion to what might be going wrong here?

Once you created the user den_copp1 did you give that user full permissions to the database....

If you have it go into cpanel, and click mysql databases.

From three scroll down to "Add User to Database" and add that user, with full permissions to the database, then try connecting again.