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
Jerry on Friendica /
npub1w9…q80dz
2025-02-17 18:24:05
in reply to nevent1q…07kf
Author Public Key
npub1w99kwr8nzh6k302q96kxl53cgj0whd5m54z6v20cjdfxtp4hzr6qaq80dzPublished at
2025-02-17 18:24:05Event JSON
{
"id": "a176ce6edd1cc9b68201b7f06be8c8df16b6133d390a3791509468f7284f6ff7",
"pubkey": "714b670cf315f568bd402eac6fd238449eebb69ba545a629f893526586b710f4",
"created_at": 1739816645,
"kind": 1,
"tags": [
[
"p",
"9fcf64ff98b21616eb79805a6ed66351033777f832a9a7c5b67f2ed686a572d7",
"wss://relay.mostr.pub"
],
[
"p",
"88a78242f698031cc5da7bed457dc72b7045d1c27b5a93c5102e1d3582229bbf",
"wss://relay.mostr.pub"
],
[
"p",
"714b670cf315f568bd402eac6fd238449eebb69ba545a629f893526586b710f4",
"wss://relay.mostr.pub"
],
[
"e",
"586d522d12ae04674cd450248a5aa6d936c7f4bfc7d41b612dd3268db538f7bb",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://my-place.social/objects/e599373b-1867-b37e-c50f-ec0969081457",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqnl8kfluckgtpd6mespdxa4nr2ypnwalcx25603dk0uhddp49wttssf9gdm 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.\n\nThe 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:\n\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '\u003cyour-new-root-password\u003e';\n\nReference: dev.mysql.com/doc/refman/8.0/e… and the section showing:\n| IDENTIFIED WITH auth_plugin BY 'auth_string'\n\nNotice, no single quotes around auth_plugin",
"sig": "b865cfb3c9dd26cdbcf7497cbf88b4982fca377eeb87183ea6a400e6e3c93d8a432784d69b708a1bd96ef2002749dfe38c563a3b3e56ca5a8a5baaeb7d007a3a"
}