Bind Address missing in my.cnf in MYSQL centos
I have hit a problem, when I edit the my.cnf for MySQL, the bind-address line is not in the file.
Here is the content of /etc/mysql/my.cnf:
# Disabling symbolic-links is recommended to prevent assorted security risks
Kindly help me to achieve this.
Just add these lines to
mysqld section depending on your preferences:
If you want it to only be accessible through localhost:
If you want it to be accessible through an interface which assigned an IP address of XXX.YYYY.WWW.ZZZZ:
If you want it to be accessible through all interfaces available, This is not recommended except when you properly configured your firewall for it: