[Solved] All My Databases Are Inaccessible

[StefaanC]

All my databases are inaccessible since yesterday, october 22th, 2015.

(database names are: tests, logboeken, astrodb)

 

I get this error:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user '*******' (using password: YES)

 

(I blanked the username here)

 

When I try to get on myphpadmin I cannot log in, I get "Server error 500"

 

 

Same shit as less than a month ago.

Can somebody please restore the access to my databases or tell me what to do.

 

 

username : stefaanc

server : stevie

domain : casierstefaan.heliohost.org

[wolstech]

The last part of the Stevie fix was installed yesterday and it broke everything again. This time around, not only did the database users break, but many databases became invisible. You need to change your cPanel password, then log out and in to fix PhpMyAdmin. Once that's done, check to see if all your databases show in PhpMyAdmin. The missing ones needs to be restored by Krydos (please post a list of database names). Once you have them all, delete and recreate your database users (again).

 

On the upside, Stevie now should have full InnoDB support for the first time in almost 2 years and is running MySQL 5.6.21 now (replacing an ancient 5.1).

[wolstech]

This support request is being escalated to our root admin.

[Krydos]

The databases stefaanc_astrodb, stefaanc_logboeken, and stefaanc_tests should now be visible to your root mysql account. You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected databases. If phpmyadmin doesn't log in properly or you don't see the database there change your account password and this should sync up the mysql/cpanel passwords. Let us know if you're still having any issues accessing your data.

[StefaanC]

Ok, thank you very much, I have everything working again now.