• How do I get database to work after restoring it?
    • After you have restored your database, you will get an error message similar to this:
    Warning: mysql_connect(): Access denied for user:
    'bakerpe_osc1@localhost' (Using password: YES) in
    /home/bakerpe/public_html/catalog/includes/functions/database.php on line 19
    Unable to connect to database server!
    Your database is in a new cPanel, but it has no username and password assigned to it.
    To assign a username and password login to your cPanel and click "MySQL Databases" Scroll down until you see the user name.
    yourusername_databasename@localhost
    The italic part would be your username. The username in our example error above is "osc1"
    You will need to find out your database password. To do so look at the error your page gave you and take note of the path.
    Path from our example error:
    /home/bakerpe/public_html/catalog/includes/functions/database.php
    You will now login to your sites FTP and go through the folders until you find the file listed in your error path. You then download the file to your computer, open it up and browse until you find your database password.
    Example of what to look for: DB_SERVER_PASSWORD\', \'nvGHdCC0dCMz\');

    nvGHdCC0dCMz would be our database password. We will now fill that password in for our database password, and then press "Add User"
    The user has now been added, but it has not been assigned to a database. Match up the user with the database it belongs to and then just click "Add user to database"