Folks, A while ago (probably bookworm), I built a MySQL server and all was well. By default, one could log in with mysql -u root and it connect via a UNIX socket and auth. This worked well and I had no complaints. At some point, which may or may not coincide with an upgrade to Trixie, this stopping working. Now, when runnig mysql -u root, I'm greeted with "ERROR 1698 (28000): Access denied for user 'root'@'localhost'" I've run mysql with strace and can see it opening the socket file corrisponding to the one in the mysqld config. I've also started mysqld with --skip-grant-tables (or something like that) and listed the user table and can see a user called root from localhost with an empty password and a plugin called "unix_socket". I'm not aware of any way to configure it to log more info regarding failed logins. It also seems fairly straight forward and as far as I can tell should "just work". Can anyone please offer any tips? I'm aware there's a couple of things one can do with --skip-grant-tables to reset the password but I'd like to diagnose the actual cause of the issue before resorting to the "factory reset password" hammer. Kind regards, Mike. PS. Yes, I know the thing I keep refering to as MySQL is actually MariaDB!
Attachment:
signature.asc
Description: PGP signature