Fair trek Posted February 4, 2016 Share Posted February 4, 2016 Username: fairtrekDatabase: StevieDomain: http://fairtrek.heliohost.org Hi, I cannot access my site, either admin or the page itself. It is showing a 500 Server Internal message. In cPanel and on the back up it comes up with: Determining mysql dbs......mysql version: 5.6......mysqldump version: 5.6...Saving mysql privs...Done ...Done Storing mysql dbs...fairtrek_ft........./usr/bin/mysqlcheck: Got error: 1049: Unknown database 'fairtrek_ft' when selecting the database(781 bytes) I haven't touched anything... Please, is it possible fix this? Thanks,G Link to comment Share on other sites More sharing options...
wolstech Posted February 4, 2016 Share Posted February 4, 2016 Probably an invisible database from the repairs last year. Escalating. Database is fairtrek_ft... Link to comment Share on other sites More sharing options...
wolstech Posted February 5, 2016 Share Posted February 5, 2016 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted February 5, 2016 Share Posted February 5, 2016 The database fairtrek_ft 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 database. 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. Link to comment Share on other sites More sharing options...
Fair trek Posted February 5, 2016 Author Share Posted February 5, 2016 HI, Thanks for this. I can now see the database and when i 'Check' it it all appears fine. However i still can't access the web page nor the admin. I have created a new user with full permissions and phpmyadmin works but still no result. Please advise... Thanks,Graham It is showing the database size as 0.0Mb in cPanel>MySQL Databases... Link to comment Share on other sites More sharing options...
wolstech Posted February 5, 2016 Share Posted February 5, 2016 I see:Database Error: Unable to connect to the Database: Could not connect to MySQL. That can be caused by three things:You forgot to change the config file for your software to match the new database user information or the username or password you entered in the file is incorrect. The host name should be localhost.You forgot to assign the user to your database, or assigned it to the wrong database.Stevie MySQL is down (it's not)PHPMyAdmin does not use the database user, so it doesn't test that. The fact you can see it there though tells me the database is fine. The permissions on the user are not the issue, you would get a different error message if they were (usually in the form "SELECT command denied for user X@localhost for database Y") The 0MB in cPanel is normal and can be ignored. All of mine show 0MB too, but have tons of data in them and work fine. Link to comment Share on other sites More sharing options...
Fair trek Posted February 5, 2016 Author Share Posted February 5, 2016 Thanks Wolstech, sorted now. Cheers,Graham Link to comment Share on other sites More sharing options...
Recommended Posts