MySQL Forums
Forum List  »  Newbie

Re: Can't connect to DB after reboot from PHP
Posted by: Peter Brawley
Date: October 28, 2021 10:18AM

Didn't you say you installed HESK then MySQL logins from your website failed till WB ran? That indicates WB is fixing something in your MySQL instance that HESK broke. HESK is PHP and MySQL. I've no knowledge of whether it installs its own copy of MySQL or piggybacks on an instance that it finds. If the latter is the case, HESK seems to have messed with an authentication setting.

If OTOH HESK has nothing to do with this, why mention it?

Another issue you may be tripping over is that MySQL 8.0 defaults to using the caching_sha2_password authentication plugin, which is incompatible with the previous default, mysql_native_password plugin.

You have at least one other issue. The website error message you cite indicates the website runs as user root@localhost. under no circumstances should an app or website do that, only sys admins should run as root.

Snark about pay is out of line, it's an open source community, most responders here including me volunteer.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.