mark edwards
Member
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');
FLUSH PRIVILEDGES ;
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');
FLUSH PRIVILEDGES ;
Last edited: