[debian-mysql] Bug#923248: mysql-server: bind-address setting ignored

[Adrian Vollmer]

Package: mysql-server
Version: 5.7.25-1
Severity: normal

Dear Maintainer,

I noticed that mysqld is listening on '*'. I did not change the default
settings and I want mysqld to listen on 127.0.0.1. I tried setting
'bind-address' in various config files but mysqld always listens on '*' (and
the port is in fact open for other systems, checked with nmap). This should
illustrate the issue:

$ grep -ir bind-address /etc/mysql/*
/etc/mysql/mysql.conf.d/mysqld.cnf:bind-address         = 127.0.0.1
$ systemctl restart mysql.service
$ ss -ntlp | grep mysql
LISTEN    0         80                        *:3306                  *:* users:(("mysqld",pid=31054,fd=29))
                                              ^-this should be 127.0.0.1

-- System Information:
Debian Release: buster/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.19.0-2-amd64 (SMP w/4 CPU cores)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mysql-server depends on:
ii  mysql-server-5.7  5.7.25-1

mysql-server recommends no packages.

mysql-server suggests no packages.

-- no debconf information