...
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
...