...
If you see an IP address of 0.0.0.0 with a port of (usually) 3306 (as below), this means MySQL is listening on all available IPs.
| Code Block |
|---|
root@dev:/etc/mysql# sudo netstat -lntup | grep mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 8491/mysqld |
You should configure the bind-address to be 127.0.0.1 in:
...
Redhat / Centos: /etc/my.cnf.d/server.cnf
| Code Block |
|---|
bind-address = 127.0.0.1 |
Credentials Encryption Key
...