mariadDB 10.4 and passwords note

hello -

it appears that with 10.4, when you are logged in as the root user, root access to the mysql CLI bypasses security. i suppose this makes sense, but it took a bit of research to figure out why the root password was being ignored.

this works to change while logged in as anything besides root:

ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('xxxxx');

Last edited: