I keep 2 copies of my wordpress directory - one copy on my hard drive, and one which I just now uploaded to my web server. My MySQL database is on a remote server.
The copy of wordpress on my hard drive connects to the DB perfectly fine. However, the copy on the server gives me an error every time. I know for certain that it has both PHP and MySQL installed on it. All files are exactly the same on my computer and on the server.
Here is the first bit of my config file:
// ** MySQL settings ** //
define('DB_NAME', 'yossarian'); // The name of the database
define('DB_USER', '****'); // Your MySQL username
define('DB_PASSWORD', '****'); // ...and password
define('DB_HOST', 'www.freesql.org'); // 99% chance you won't need to change