Website Down For Two Weeks

[codename25]

Hi,

My website is entirely connected with the database. For two weeks i am unable to establish a connection with the database. My website is showing database error instead of homepage. Its very awkward moment. Its totally out of my control. This is going to effect the traffic very badly. Please help to solve this issue as soon as possible.

 

Thank you.

[yashrs]

You need to reset the database permissions from the cPanel to fix this problem.

[codename25]

Thanks for the reply. Reset database permission? How should i do that.

 

Thanks for the reply. Reset database permission? How should i do that.

[yashrs]

Delete and create a new database user which is in the form username_dbuser, then update your software's config file and it will work again.

[codename25]

Hi,

I first took back up of the table and deleted the user. i restored the tables with the same user name. but it didnt solved the problem showing this error.

 

Access denied for user 'xxx'@'localhost' (using password: YES) in /home1/xxx/xxx/xxx/ on line 10

Access denied for user 'xxx'@'localhost' (using password: YES)

[wolstech]

You need to fix the user not the database itself. The relevant tools are at the bottom of this page: http://stevie.heliohost.org:2082/frontend/x3/sql/index.html

 

You should not need to touch any database tables, or even open PHPMyAdmin to fix this.

[codename25]

I have deleted the previous user and created a new user. But it didnt solved the issue. How should i update softwares config file. And what is 'software' meant by?