Unable to connect to database. - RESOLVED

Permalink 1 user found helpful
I'm moving a site from localhost to a web server and but I end up with the following when I log into the site:

"Unable to connect to database. A database error occurred while processing this request."

I can see the concrete5 bar at the top so I know the files are there, I have imported everything to the database and that should be fine. My config/site.php is similar to the following(don't want to give away the credentials). The actual site can be viewed at "http://eclinical.exstream.tv" for reference.

<?php
define('DB_SERVER', 'mysql-f11b.mysqldbserver.com');
define('DB_USERNAME', 'seen72'); /* also tried 'seen72_mysql-f11b.mysqldbserver.com' */
define('DB_PASSWORD', 'Pelic@n!');
define('DB_DATABASE', 'seen72_mysql-f11b.mysqldbserver.com'); /* also tried 'seen72') */
define('DIR_REL', '');
define('BASE_URL', 'http://eclinical.exstream.tv');
define('PASSWORD_SALT','OfD1wSaM1RBJb2CjglapXLuCtIgEa7xTnC9y4iTDSe7XRk2VkRoQHveDlMWJvFxx');
?>

I've searched through just about every concrete5 discussion I can find and can't find a way to remedy the situation. Been at it for 7 hours and at a loss. I also know very little php. Any help anyone can offer would be greatly appreciated as I'm hard up on a deadline.

lackadaize
 
lackadaize replied on at Permalink Reply
lackadaize
my localhost server is set up for PHP extension: mysqli while the server I'm migrating to is set up for PHP extension: mysql. Does this matter?
lackadaize replied on at Permalink Reply
lackadaize
also, my localhost is Apache 2.2 while the server I'm migrating the site to is iis/6.0
exchangecore replied on at Permalink Reply
exchangecore
Are you sure that you are using the actual name of your database? What you have posted in the following line seems very long, it is looking for a database name, not a host name keep in mind:

define('DB_DATABASE', 'seen72_mysql-f11b.mysqldbserver.com'); /* also tried 'seen72') */
lackadaize replied on at Permalink Reply
lackadaize
I did 'seen72' which I believe is the correct name, as that is what shows up in phpMyAdmin as the database name. When I do that and leave username as 'seen72' the page goes blank (no error, not nothing) and I'm not sure if that I sign that I'm going in the right direction or not. The source code for this reads as:

<html>
<head>
</head>
<body>
</body>
</html>

so I'm guessing this is the wrong direction.
lackadaize replied on at Permalink Reply
lackadaize
searched all the "blank page" threads to no avail.
lackadaize replied on at Permalink Reply
lackadaize
permissions for /packages /updates /config /files /sitemap.xml are all read/write/executable.
lackadaize replied on at Permalink Best Answer Reply
lackadaize
turns out that my MySQL tables were created as all lowercase. I went in and manually changed the tables through phpMyAdmin to camelCase.