Slinack Posted November 26, 2015 Posted November 26, 2015 Hi, I've been having some trouble when trying to connect to my page. I get the following error: An error was encounteredError: Unable to connect to MySQL and select database. MySQL reported: Access denied for user 'twbrasil_flux333'@'localhost' (using password: YES). Heliohost user: twbrasilDomain: www.teeworldsbr.com It's been like that for a while. Since mysql error were common, I thought it'd go away sometime. What's worse: I don't remember that password to access phpMyadmin or else. I can only login to my cpanel account. I appreciate the help, thanks!
wolstech Posted November 26, 2015 Posted November 26, 2015 Change your cPanel password, then log out and in again to fix phpmyadmin. Once you can get into phpmyadmin, check that all your databases are there. If any are missing, post their names so I can have them fixed for you. Once the databases are restored, you'll need to delete and recreate the users.
Slinack Posted November 27, 2015 Author Posted November 27, 2015 I think I only had this one database for the forum "twbrasil_flux333"... But it seems to be empty now.
wolstech Posted November 27, 2015 Posted November 27, 2015 This support request is being escalated to our root admin.
Krydos Posted November 27, 2015 Posted November 27, 2015 The database twbrasil_flux333 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.
Slinack Posted November 27, 2015 Author Posted November 27, 2015 You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected database. I'm not sure I understand what I am supposed to do.In my cpanel account, if I go to MySQL Databases there is this "Current Users" field. It shows a single "twbrasil_flux333". Is this the one I should delete and recreate? Would I lose anything in the process? Sorry for all these questions. Thanks again!
wolstech Posted November 27, 2015 Posted November 27, 2015 Every user under "current users" will need to be recreated. The password for the new user will be found in your software's configuration file (I don't know where fluxbb stores its database settings, usually there's a config.php or similar-named file that will have the database information in it). Once you recreate it, you'll need to reassign the user to the database as well (it'll ask for permissions to grant, select "All privileges" if you don't know).
Slinack Posted November 27, 2015 Author Posted November 27, 2015 I've recreated the user, and reassigned it to the database. But now I get this "400 bad request" when trying to load the webpage.I tried to look up the error log on cpanel, but it's blank.Any clues?
Slinack Posted November 27, 2015 Author Posted November 27, 2015 Yeah, it's probably something on my side now. I could open it on my mobile. Thanks for the help guys! You can close the topic Have a nice day.
Recommended Posts