Drupal_2

3, a photo by drtbalu on Flickr.

drupal_1

2, a photo by drtbalu on Flickr.

1

1, a photo by drtbalu on Flickr.

Moodle database errors how to trouble shoot

Suddenly couple of days back my moodle site threw the following error “Error: Database connection failed.
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php”

How to manage this situation?

I was perplexed since I have not made any changes to my moodle database. Then I logged into my cpanel and found that my Cpanel has been upgraded to a current version.
I did a quick Mysql data base check through the script available in my cpanel. Everything was fine. They I opened the moodle config file and checked up. The user name and pass word was correctly given in the config file.
Then I checked up the data base. To my surprise the user name which i had created when I installed moodle a couple of years back was missing.
Through the cpanel itself I recreated the same user name as in the config file and inserted the same password. Saved the settings.
Now the site is up and running fine.