Re: Can't connect to DB after reboot from PHP

[Peter Brawley]

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.