I'm not clear if this is an issue, but I think it needs investigating.
DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server
dpkg-reconfigure mysql-server (with root password)
Switch to non-root Unix user
Log in with mysql client as MySQL root user
Expected behaviour: login successful
Actual behaviour: login refused
Was this case considered when doing the Unix socket auth? Is the issue that the password was initially blank and then set later, or does it do it even if the password was initially set? If the former then this probably isn't as important as the latter case.
I'm not clear if this is an issue, but I think it needs investigating.
DEBIAN_ FRONTEND= noninteractive apt-get install -y mysql-server
dpkg-reconfigure mysql-server (with root password)
Switch to non-root Unix user
Log in with mysql client as MySQL root user
Expected behaviour: login successful
Actual behaviour: login refused
Was this case considered when doing the Unix socket auth? Is the issue that the password was initially blank and then set later, or does it do it even if the password was initially set? If the former then this probably isn't as important as the latter case.