• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

Database Error: Unable to connect to the database:Could not connect to MySQL

My web site and administration panel is producing the following message when I open them, Database Error: Unable to connect to the database: Could not connect to MySQL,

I have no idea when this message appeared but I found it yesterday. The web site is www.townsvilepilots.com.au it is Joomla based. I have no backup of the data base so a reinstall is not possible at this stage, any help would be appreciated.

Regards, Chris
0
CBJ
Asked:
CBJ
  • 7
  • 4
  • 3
1 Solution
 
Panagiotis Sweb developer - designer Commented:
The Web site cannot be found

0
 
CBJAuthor Commented:
My Mistake, http://townsvillepilots.com.au 

regards, Chris
0
 
Panagiotis Sweb developer - designer Commented:
check your configuration file to see if the db user, db name are correct
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
boraganeshCommented:
check DB username, password and allowed access to Db. Also check port configuration
0
 
CBJAuthor Commented:
Hi
looked into configuration.php file for DB user and DB name both are the same as when DB created,  also noticed that I cannot log into myphp admin using username and password.  Regards,  Chris.
0
 
Panagiotis Sweb developer - designer Commented:
have you changed anything in the db settings, or maybe your host did an upgrade.
Its a mysql problem
0
 
boraganeshCommented:
do you have root username password? login with root user name from console/ comand promt. and grat all privileges  
0
 
CBJAuthor Commented:
This is where I need help, what is console / command prompt and how do I achieve this.

Regards, Chris.
0
 
Panagiotis Sweb developer - designer Commented:
in order to have command prompt you need to have ssh with your server.
If its a dedicated server then you probably have otherwise ask your host to do it for you
0
 
CBJAuthor Commented:
Server is not dedicated but I can log into using Cpanel. I’ll check if I have SSH enabled and report back.

Regards, Chris.
0
 
CBJAuthor Commented:
Now have SSH access and can connect using Putty software using my Ip, username and password, what do I do now?

Regards, Chris.
0
 
CBJAuthor Commented:
Thank you all for assisting in solving this problem, I contacted the hosting provider and they responded with this
 “The password the site was using to access MySQL was incorrect. I've updated the password and put the new password in the config file. I believe this was the result of an update enforcing a password security policy, though I am not sure”.

regards, Chris.
0
 
CBJAuthor Commented:
Great work, I wish I was this smart!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 7
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now