Help websitte cannot connect to database

[---firefly---]

Hi,

My websites can't connect to the database any more. My first website is at http://www.devonianmists.com and is running zen cart. It all worked fine until a few months ago (haven't had the time to sort it out 'til now), and now it won't connect. I haven't changed anything since before it was working.

I noticed some time ago some threads about changing the mysql local host on some servers, this was about the time mine stopped working, but I think I remember reading to change it to something else then back to localhost, so I didn't change it at all. I can't find that thread anymore, anyone know where it is? I am hosted on cossacks.

My config files are set up as :

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'devonian_firefly');
define('DB_SERVER_PASSWORD', '**********');
define('DB_DATABASE', 'devonian_mists');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

My second website also has the same problem with the other database on my account, using equivalent config info.

Any help much appreciated!

(My account username is devonian and primary domain is http://mists.elementfx.com)

 

[GamingX]

*Moved to Level 2 Support

 

[Fedlerner]

Fixed. In the sticky thread, Corey told to remove your MySQL user, and re-add it.
I've done this for your account and your websites are working fine now.

Feel free to re-open this thread if you need further assistance.