mysql db server; php connecting error

[rebelsforchrist]

Hey,
I tried localhost, and I also tried mysql.x10hosting.com.
I'm not sure what works for the db server to allow me to connect to the mysql database that I made via the cpanel.

bugfinder confirmed that the hostname is in fact localhost

define("DB_SERVER", "localhost");
define("DB_USER", "rfc1_rfcuser");
define("DB_NAME", "rfc1_rfc");
those are the 3 php constants that i am using.

here is the error i get:
Access denied for user 'rfc1_rfcuser'@'localhost' to database 'rfc1_rfc'
http://rebelsforchrist.com

Thanks much,
matthew

 

[Brandon]

You need to grant privileges to the mysql user with the mysql database via cPanel. It's tward the bottom of the MySQL page.

 

[rebelsforchrist]

i chose the privileges. then, it said " MySQL® Database Wizard; User was added to the database ."
then, i hit go back.
then, the page seems to look the same as it did before i hit add user:

 

[Brandon]

See were it says 'Add User to Database', select them there and click 'All Privileges'.

 

[rebelsforchrist]

hmm, i did that, but no luck. i hit the 'add' button there. i chose all privs. then i hit go back after submitting the changes. and, it looks the same and gives same error on the webpage.

 

[bugfinder]

Im going to suggest you didnt click the "Make changes" button as I just tried it on your account and it went straight through.

 

[rebelsforchrist]

hey bugfinder, that's extremely strange that it worked for you. thanks a lot for doing this on my account for me. by 'hitting the submit button', i mean i hit the make changes button after i had chosen all privs. it's really strange. maybe it's because i checked the all privs box instead of checking each individual box.
thanks to both!