paladox2014 Posted September 15, 2015 Posted September 15, 2015 Hi since the recent update to cpanel and stevie it seems innodb has been disabled and hidden. There is no option to select it. MySQL just came up.
wolstech Posted September 15, 2015 Posted September 15, 2015 Doesn't seem to be up. All my sites are still showing the access denied error and I can't even get into phpmyadmin. InnoDB was turned off a week or so ago, before this issue happened. InnoDB tables all show as "in use" now, and imports will fail with "unknown engine" as opposed to ghost tables.
paladox2014 Posted September 15, 2015 Author Posted September 15, 2015 Ok when will innodb be turned on and its working for me. try deleting the user on MySQL and then re create the user and re add to the databases. then log into MySQL phpmyadmin once logged in and shows either a blank screen try refreshing by doing f5.
wolstech Posted September 15, 2015 Posted September 15, 2015 It was indeed dead database users. I deleted mine and recreated them and they work. Still doesn't explain PHPMyAdmin though...
paladox2014 Posted September 16, 2015 Author Posted September 16, 2015 If you login into phpmyadmin then refresh page after logging in if it shows the normal http error in Internet explorer. Refresh page by doing f5 on internet explorer, Google chrome, Microsoft edge.
paladox2014 Posted September 16, 2015 Author Posted September 16, 2015 Hi could innodb be re enabled since that is why stevie was upgraded to fix the innodb problem and MySQL keeping going down.
wolstech Posted September 16, 2015 Posted September 16, 2015 It didn't fix the problem. It's part of a fix that I don't think is fully implemented yet. On the upside, with it entirely disabled, MySQL shouldn't crash so much because you can't even do stuff like try to create innodb tables. It just errors saying unknown engine instead of crashing the server.
paladox2014 Posted September 16, 2015 Author Posted September 16, 2015 Ok when will innodb be switched on because I thought it wasent be switched off because users have innodb tables.
wolstech Posted September 16, 2015 Posted September 16, 2015 Most that needed to use their sites converted to MyISAM in the 18 months it was broken. You should do the same. I don't know when or if InnoDB will be restored.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now