[Solved] Mysql Database Not Connecting

[tagomago]

Hi, I have been having problems with my website over the last few days. There seems to be a problem connecting to the MySQL database. I get the following error trying to access the main page...

 

Unable to connect to database [Access denied for user 'tagomago@localhost' (using password: YES)]

 

When I try and access the database through phpMyAdmin it goes to a login screen when I type in the details that I use to login to cPanel it goes to a page saying 'HTTP 500 Internal Server Error'.

 

Is there a problem with the server at the moment? Will this fixed in a few days?

[wolstech]

There's a lot of users on Stevie with this issue. I'm affected too There's been no information on this issue, even internally to the mods. I'm hoping it gets fixed soon.

 

Moving to customer service.

[wolstech]

The Access Denied errors seen on websites are fixable by deleting and recreating the database user. Be sure to reassign it to the database after deleting and recreating it.

 

PhpMyAdmin and your cPanel MySQL account are still broken though (sometimes changing your password will fix these, but it did not when I tried it).

[tugastat]

I had these problems with connecting and PhpMyAdmin as well. Changing the password worked like a charm.

[tagomago]

Thanks that worked for me too!

[tugastat]

Although changing the password solved the connection issue and that all my data and triggers are intact, all my stored procedures are gone.

I didn't made any backup.

Is it possible to recover stored procedures?

[colette]

I had a problem connecting to the MySQL database (error 2).

When changing user's password, I got:

Although the system’s database map includes a MySQL user named “xxxx_xxxxxx”, the MySQL server reported that no user with this name exists. Contact your system administrator.

I add a new privileged user and change configuration file. It works.

 

Thanks!