codename25 Posted October 7, 2015 Posted October 7, 2015 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. Quote
yashrs Posted October 7, 2015 Posted October 7, 2015 You need to reset the database permissions from the cPanel to fix this problem. Quote
codename25 Posted October 7, 2015 Author Posted October 7, 2015 Thanks for the reply. Reset database permission? How should i do that. Thanks for the reply. Reset database permission? How should i do that. Quote
yashrs Posted October 7, 2015 Posted October 7, 2015 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. Quote
codename25 Posted October 9, 2015 Author Posted October 9, 2015 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 10Access denied for user 'xxx'@'localhost' (using password: YES) Quote
wolstech Posted October 9, 2015 Posted October 9, 2015 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. Quote
codename25 Posted October 10, 2015 Author Posted October 10, 2015 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? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.