Warning: Urgent help needed - mysql_connect() [function.mysql-connect]

[debbyds]

Hi All,

 

  I wonder if someone can help me asap as my shop is now unaccessable

 

I changed the password for my cpanel and now when I go into my shop or try to access my cubecart admin I get the following message..

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '**'@'localhost' (using password: YES) in /home/**/public_html/shop/classes/db/db.php on line 37
Access denied for user '**'@'localhost' (using password: YES)

 

I remember this happening a long while back and I remember changing the password in a file to match the cpanel one and it sorted the problem out.

 

From reading up online for the past few hours I thought I'd found the solution by changing the password in the global.inc.php file. However I have done this and am still getting the same problem.

 

I also changed the database password to match but thats not solved it either

 

I'm sure it is solved by changing a password in a file somewhere to match my new cpanel password but after going through tons of files I can't find anywhere else to change it or discover what else I can do - it's driving me crazy and If I don't sort it tonight I won't be able to sort it again until tomorrow night and will in the meantime lose custom

 

If someone can help me asap I will be really greatful!!

 

Thank you,

 

Debby

[bsmither]

$glob['dbpassword'] = 'something';

in /includes/global.inc.php is the place to put your MySQl database password.

 

But your database password may be a variant of your cPanel password, like:

nameOfDatabase_cPanelPassword

for example: crt1_secretcode

but having a database password so much very like the cPanel password is not something I often see.

 

The 'current' password for your database should be shown to you in the "MySQL Databases" screens in cPanel.

[debbyds]

Hi,

 

  Thank you so much for your reply.

 

In the global.inc.php file, on the '$glob['dbpassword'] =' line I have the password of the database user.  On the '$glob['dbdatabase'] =' line I have the name of the database - I'm sure that's correct, isnt it?

 

But it still shows me the same problem, therefore there is something Im either doing wrong or haven't done

 

 In MySQL Databases in my cpanel, I deleted the db user and then added it again so that I could change the password to ensure I was using the correct one but that hasn't helped.

 

I've also sent an email to my host to ask for help, but they've not replied yet.

 

I can't think what else to do.

 

 

Debby

[debbyds]

Problem resolved My host did it for me.

 

Thanks again for the help!

 

Debby