My Website Is Not Connecting With Mysql Database

[rahuld147]

Hello,

 

My website: pricetau.com is on Stevie server and my cPanel username is: rahuld14

 

I am observing this error from more than 24 hours now:

 

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'rahuld14_mrres'@'localhost' (using password: YES)

 

Yesterday when I checked the Service Status link under cPanel, it was showing MySQL to be down but now it shows MySQL service to be up and running but I am still getting this error!

 

When I am trying to access phpMyAdmin from cPanel I see this error (see screenshot)

 

 

Please do something to get it fixed ASAP.

 

Thanks & Regards,

Rahul Dhangar

[wolstech]

Delete the user mrres then recreate it. Make sure to use the same password as last time (find it in the config file for your software), and reassign it to the database.

[rahuld147]

Hello Support Admin,

 

I did exactly what you said; I recreated the user mrres again with same password as before and assigned it to the database. But now my website is gone! All I see is this error (see screenshot) :

 

 

Also, when I access phpMyAdmin now I only see the table structures of all those tables which were previously there before MySQL server malfunctioned and went down 2 days ago. All my tables data is lost now! I have no clue what to do now

 

Please help!

 

Also, one more problem... actually the database is empty now (there are no table structure present in it) but I still see the tables name in the left hand sidebar and no tables on the Structure tab. See screenshot:

 

 

I am fu*%&ed up

 

I am deleting the whole database and recreating it again. Anyways, my thread will help the Administrators to debug the issue to make sure nothing like this happens again.

 

Thanks

[RohitKumar79]

Hey I did as suggested.

Reset the c panel password with 'synchronize mysql password' enabled.

Deleted the database user and created a new one with same name and same password.

Now i can access the phpmyadmin and can see all tables but when i click on the tables "#1146 table doesn't exist" appears.

I would like to tell you that I can access one table which was of type 'MyISAM' but all others with type 'InnoDb' cannot be accessed.

 

Please help.

Thanks.

[wolstech]

InnoDB is broken again.

 

You need to create a new database with a different name. Try restoring a backup into that database and see if it works.

[RohitKumar79]

I tried creating a backup, but the backup also doesn't have the tables. It has only one table of 'MyISAM'.

Is there any other way to backup my data??

[wolstech]

You need to use a backup from before the incident.