Error establishing database connection

[mawsonii70]

I'm trying to set up a website using WordPress for a class I'm taking at the local community college. Apparently, I need to set up a mySQL database. I've made numerous attempts and keep getting the subject message. I've gone to the forum and looked at four different suggestions on how to correct this problem without success. Please help me. I'm facing a deadline.

[descalzo]

1. You can use the script installers from cPanel if you wish. They do it all for you.

2. If you want to install WP manually, to make your DataBase,
a. go to cPanel --> MySQL Databases
b. create your database, the final name will be foo_yelp where 'foo' is your cPanel username, and 'yelp' is the name you supplied
c. Create a user. I usually use the same name as the database for simplicity. WRITE DOWN THE PASSWORD YOU GIVE IT.
d. Add the user to the database. Check the "ALL PRIVILEGES" box when the pop-up comes.

3. Now run your WP install script with the information you just used for your database and user. The hostname is "localhost"