There is a piece of code in init.d script that checks if mysql is operational.
/etc/init.d/mysql
128 if ! $(mysqladmin --no-defaults --socket=“$socket” --user=UNKNOWN_MYSQL_USER ping &>/dev/null) ;then
129 ping_alive=0
130 fi
It’s working fine for a check, but if you use auth_pam_compat plugin, trying to authenticate with UNKNOWN_MYSQL_USER will give non-zero return code, and, thus will fail systemd unit. The reason for that is in client parameters. --enable-cleartext-plugin option should be provided on cli. But, IMO, this behaviour should be reflected in init script.
1 Like
Hello Alex, thanks for spotting this. May I ask you to open a bug at jira.percona.com so dev can look into this?
1 Like
thank you for the report!
1 Like