New user seeking WordPress help

[RFH Customer: markcannon]

Hi, I'm new to RedFox, WordPress and MySql so be gentle please :-)

I'm trying to run WordPress and having followed installation instructions have arrived at the error message:
" Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?"

So, what did I do to get where I am.
• created a new MySql database and database user from HELM

• added the database name, username and password to 'wp-config.php' like this:
define('DB_NAME', 'mydatabasename'); // The name of the database
define('DB_USER', 'mydatabaseusername'); // Your MySQL username
define('DB_PASSWORD', 'mydatabasepassword'); // ...and password
The next line I've left untouched so it still appears as is.
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

• Uploaded the entire WP directory in to wwwroot so that it's a sub-directory of my site, making sure that the WP directory name is the same as in the config file.

• Pasted in to the browser address window
http://www.mysite/sub-directory/wp-admin/install.php
as per the instructions and ended up with the error message.

Where now. I'm sure that the database name, username and password are correct.However,
• how do I check that the hostname is correct and that the database is runnning?

• If the hostname shouldn't be 'localhost', what should it be?

• have I missed something out in the database creation? If so what?

Sorry for this being a loooong first post, I'm very much a fartie at this and wanted to provide plenty of info.

Oh and I'm a Mac user, running OS 10.4 and using Transmit as my ftp client.

Thanks in advance
Mark

[Staff: Warren Ashcroft]

• added the database name, username and password to 'wp-config.php' like this:
define('DB_NAME', 'mydatabasename'); // The name of the database
define('DB_USER', 'mydatabaseusername'); // Your MySQL username
define('DB_PASSWORD', 'mydatabasepassword'); // ...and password
The next line I've left untouched so it still appears as is.
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

DB_HOST isnt correct, see helm for the database server name of your database.

[RFH Reseller: nick]

change 'localhost' to 'HYDROGEN'.

Good to see another mac man using transmit, snap

[RFH Customer: markcannon]

Folks
Many thanks for the swift help.

It's always something easy and yep, localhost changed and I'm up and running.

Thanks again

Mark