Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at

RSS Latest posts from my personal blog

Most viewed posts

Subscribe to RSS feed

Restrict mysql to listen only on localhost (CentOS)

Stanislav KhromovStanislav Khromov

In /etc/my.cnf config file, under the [mysqld] line, add:

bind-address =


Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
Twitter Profile
Visit my other blog

Comments 1
  • Ralf
    Posted on

    Ralf Ralf

    Reply Author

    this is only for localhost on IPv4. On IPv6 mysql will still listen an all configured IPv6 ip addresses