Bind Address missing in my.cnf in MYSQL centos

mysql centos my.cnf
Megha Sharma picture Megha Sharma · May 15, 2014 · Viewed 19.3k times · Source

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:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Kindly help me to achieve this.

Answer

mdh.heydari picture mdh.heydari · Oct 22, 2015

Just add these lines to mysqld section depending on your preferences:

  1. If you want it to only be accessible through localhost:

    bind-address=127.0.0.1

  2. If you want it to be accessible through an interface which assigned an IP address of XXX.YYYY.WWW.ZZZZ:

    bind-address=XXX.YYYY.WWW.ZZZZ

  3. If you want it to be accessible through all interfaces available, This is not recommended except when you properly configured your firewall for it:

    bind-address=0.0.0.0

Related questions

my.cnf file missing and cannot be found at any directory

I recently removed mysql 5.1 an installed mysql 5.6 on my CENTOS 6 x86 OS. When I try to look for the my.cnf file it is missing from these directories: mysqld --verbose --help | grep -A 1 "Default options" = /etc/my.cnf, /etc/mysql/…

Read More
Centos 6 64bit enable my.cnf

Can someone please tell me how to enable my.cnf options in CentOS 6? I have all the expected .cnf files in /usr/share/mysql but they simply don't work. /etc/init.d/mysqld --help --verbose Usage: /etc/init.d/mysqld {…

Read More
Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

I installed MariaDB on CentOS 7 but I had some problems with some configuration, now it is completely misconfigured. Thus, I wanted to remove the MariaDB with “yum remove mariadb mariadb-server”, after that I reinstalled it with “yum install mariadb mariadb-server”. …

Read More