kaisercoins Posted June 11, 2015 Share Posted June 11, 2015 Hi! For some reason I cannot access any MySQL database on Johnny. I haven't changed anything on the database. They were working fine for months until yesterday. It responses with "Access Denied". When I run "Check DB" at cPanel it responses with: "No database found".Any idea? Please let me know if you need more information. Thank you! Link to comment Share on other sites More sharing options...
wolstech Posted June 11, 2015 Share Posted June 11, 2015 We broke a bunch of databases trying to fix the frequent database server crashes. Krydos has to fix this. Escalating. Link to comment Share on other sites More sharing options...
Krydos Posted June 12, 2015 Share Posted June 12, 2015 Make sure you get the database name before escalating it otherwise I can't do anything to help. The database name will start with your username followed by an underscore such as "user_database". Link to comment Share on other sites More sharing options...
kaisercoins Posted June 12, 2015 Author Share Posted June 12, 2015 My username is mykaiser. Hence, I have the following database names:mykaiser_production_dbmykaiser_productionmykaiser_mastermykaiser_dev_dbmykaiser_db_newmykaiser_dbmykaiser_test_db Link to comment Share on other sites More sharing options...
Krydos Posted June 12, 2015 Share Posted June 12, 2015 All of the databases that you listed 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. Let us know if you need an further help with this. Link to comment Share on other sites More sharing options...
kaisercoins Posted June 12, 2015 Author Share Posted June 12, 2015 <div>Thank you for your answer. I tried to change password. However I got this on cpanel. Any idea?<br />"Although the system’s database map includes a MySQL user named “mykaiser_user”, the MySQL server reported that no user with this name exists. Contact your system administrator."</div><div> </div> Link to comment Share on other sites More sharing options...
Krydos Posted June 12, 2015 Share Posted June 12, 2015 Have you tried deleting that MySQL user and recreating it? Link to comment Share on other sites More sharing options...
kaisercoins Posted June 12, 2015 Author Share Posted June 12, 2015 That worked ;-) Thank you for your great support! Link to comment Share on other sites More sharing options...
Krydos Posted June 12, 2015 Share Posted June 12, 2015 No problem. Glad everything is working for you again. Link to comment Share on other sites More sharing options...
Recommended Posts