Date: Mon, 27 Apr 2026 13:24:15 -0700 From: "Dan Mahoney (Ports)" <freebsd@gushi.org> To: William Dudley <wfdudley@gmail.com> Cc: questions@freebsd.org Subject: Re: HELP! mysql-server broken on FreeBSD 13 Release p12 Message-ID: <CD1E3062-4850-4A8B-80EF-B8A6CBE6631D@gushi.org> In-Reply-To: <CAFsnNZKLk6asin2KiYQGLknCiicRkyowjAtcJh-oerP4v0v0wA@mail.gmail.com>
index | next in thread | previous in thread | raw e-mail
> On Apr 27, 2026, at 1:10 PM, William Dudley <wfdudley@gmail.com> wrote: > > During a recent pkg upgrade, pkg uninstalled my mysql server. I saw that, but I figured > that some other thing had happened so I'd still have mysql running. HAH! > I rebooted the machine last night, and the running instance of mysql80-server > obviously disappeared. > > I installed mysql84-server, but it fails, and mysql-client complains: > ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded > The fix for this seems to involve having a running mysql server. This is a version of password authentication that's going away in future versions of MySQL and did not survive the fork to MariaDB, and is presently off by default. If you don't have your database passwords and cannot re-password them, at least mysql84 and earlier have this option you can set in my.cnf, but this is a compatibility shim and you should move to something newer as soon as you can. Try this, and see what's in your error log after? [mysqld] mysql_native_password=ON -Danhome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CD1E3062-4850-4A8B-80EF-B8A6CBE6631D>
