Jerry on Friendica on Nostr: Elena Rossini ✨🎥 This is what self-hosting is about. Living in a cloud of ...

Elena Rossini ✨🎥 (nprofile…9gdm) This is what self-hosting is about. Living in a cloud of confusion because you're dealing with a bunch of different tech, none of which you'd ever be able to become an expert in. So, there's a lot of trial and error. This is so familiar. And the fun of it.

The ALTER statement format, I believe, is wrong. It is showing single quotes around "mysql_native_password" which makes it a literal string. But, IDENTIFIED WITH specifies the name of the authentication plugin, not a string. Can you try instead:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your-new-root-password>';

Reference: dev.mysql.com/doc/refman/8.0/e… and the section showing:
| IDENTIFIED WITH auth_plugin BY 'auth_string'

Notice, no single quotes around auth_plugin