{"id":3407,"date":"2020-06-03T12:11:39","date_gmt":"2020-06-03T17:11:39","guid":{"rendered":"http:\/\/www.incredigeek.com\/home\/?p=3407"},"modified":"2020-06-03T12:11:40","modified_gmt":"2020-06-03T17:11:40","slug":"the-mysql-service-is-currently-configured-to-listen-on-all-interfaces-bind-address","status":"publish","type":"post","link":"https:\/\/www.incredigeek.com\/home\/the-mysql-service-is-currently-configured-to-listen-on-all-interfaces-bind-address\/","title":{"rendered":"The MySQL service is currently configured to listen on all interfaces: (bind-address=*)"},"content":{"rendered":"\n<p>Open up the my.cnf file<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">vi \/etc\/my.cnf<\/pre>\n\n\n\n<p>Add the following line so MySQL will only work from the server.  Basically blocks all remote MySQL conenctions.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Configure bind-address=127.0.0.1<\/pre>\n\n\n\n<p>Restart the MySQL service<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">systemctl restart mysqld<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Open up the my.cnf file vi \/etc\/my.cnf Add the following line so MySQL will only work from the server. Basically blocks all remote MySQL conenctions. Configure bind-address=127.0.0.1 Restart the MySQL service systemctl restart mysqld<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[195],"tags":[196,1042,136,503,382],"class_list":["post-3407","post","type-post","status-publish","format-standard","hentry","category-cpanel","tag-cpanel-2","tag-my-cnf","tag-mysql-2","tag-security","tag-whm"],"_links":{"self":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/3407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/comments?post=3407"}],"version-history":[{"count":1,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/3407\/revisions"}],"predecessor-version":[{"id":3408,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/3407\/revisions\/3408"}],"wp:attachment":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/media?parent=3407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/categories?post=3407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/tags?post=3407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}