{"id":4016,"date":"2023-02-08T13:34:48","date_gmt":"2023-02-08T08:04:48","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=4016"},"modified":"2023-02-08T13:34:48","modified_gmt":"2023-02-08T08:04:48","slug":"mysql-mariadb-server-bind-to-multiple-ip-address","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/","title":{"rendered":"MySQL\/MariaDB Server: Bind To Multiple IP Address"},"content":{"rendered":"<p>To bind a MySQL\/MariaDB server to multiple IP addresses, you can follow these steps:<\/p>\n<ol>\n<li>Open the MySQL\/MariaDB configuration file:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-bash\">sudo nano \/etc\/mysql\/my.cnf<br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"2\">\n<li>Locate the <code>bind-address<\/code> directive and comment it out or delete it:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-comment\"># bind-address           = 127.0.0.1<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"3\">\n<li>Add the following lines to the configuration file to specify the IP addresses that the server should listen on:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-css\">bind-<span class=\"hljs-selector-tag\">address<\/span>           = <span class=\"hljs-number\">192.168<\/span>.<span class=\"hljs-number\">1.10<\/span><br \/>\nbind-<span class=\"hljs-selector-tag\">address<\/span>           = <span class=\"hljs-number\">192.168<\/span>.<span class=\"hljs-number\">1.11<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>Replace <code>192.168.1.10<\/code> and <code>192.168.1.11<\/code> with the IP addresses that you want the server to bind to.<\/p>\n<ol start=\"4\">\n<li>Save the configuration file and restart the MySQL\/MariaDB server:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs\">sudo service mysql restart<br \/>\n<\/code><\/div>\n<\/div>\n<p>After these steps, the MySQL\/MariaDB server will listen on all specified IP addresses. This can be useful if you want to allow connections to the server from multiple network interfaces, or if you want to separate different types of traffic to different IP addresses.<\/p>\n<p>Note: If you bind the server to multiple IP addresses, it&#8217;s important to properly secure the server to prevent unauthorized access to the database. You should also configure firewalls and other security measures to restrict access to the server to trusted sources.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To bind a MySQL\/MariaDB server to multiple IP addresses, you can follow these steps: Open the MySQL\/MariaDB configuration file: sudo nano \/etc\/mysql\/my.cnf Locate the bind-address directive and comment it out or delete it: # bind-address = 127.0.0.1 Add the following lines to the configuration file to specify the IP addresses that the server should listen &#8230; <a title=\"MySQL\/MariaDB Server: Bind To Multiple IP Address\" class=\"read-more\" href=\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\" aria-label=\"Read more about MySQL\/MariaDB Server: Bind To Multiple IP Address\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4016","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"To bind a MySQL\/MariaDB server to multiple IP addresses, you can follow these steps: Open the MySQL\/MariaDB configuration file: sudo nano \/etc\/mysql\/my.cnf Locate the bind-address directive and comment it out or delete it: # bind-address = 127.0.0.1 Add the following lines to the configuration file to specify the IP addresses that the server should listen ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-08T08:04:48+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"MySQL\/MariaDB Server: Bind To Multiple IP Address\",\"datePublished\":\"2023-02-08T08:04:48+00:00\",\"dateModified\":\"2023-02-08T08:04:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\",\"name\":\"MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-02-08T08:04:48+00:00\",\"dateModified\":\"2023-02-08T08:04:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\/MariaDB Server: Bind To Multiple IP Address\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/","og_locale":"en_US","og_type":"article","og_title":"MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice","og_description":"To bind a MySQL\/MariaDB server to multiple IP addresses, you can follow these steps: Open the MySQL\/MariaDB configuration file: sudo nano \/etc\/mysql\/my.cnf Locate the bind-address directive and comment it out or delete it: # bind-address = 127.0.0.1 Add the following lines to the configuration file to specify the IP addresses that the server should listen ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/","og_site_name":"TrySitePrice","article_published_time":"2023-02-08T08:04:48+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"MySQL\/MariaDB Server: Bind To Multiple IP Address","datePublished":"2023-02-08T08:04:48+00:00","dateModified":"2023-02-08T08:04:48+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/","url":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/","name":"MySQL\/MariaDB Server: Bind To Multiple IP Address - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-02-08T08:04:48+00:00","dateModified":"2023-02-08T08:04:48+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/mysql-mariadb-server-bind-to-multiple-ip-address\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL\/MariaDB Server: Bind To Multiple IP Address"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=4016"}],"version-history":[{"count":1,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4016\/revisions"}],"predecessor-version":[{"id":4017,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4016\/revisions\/4017"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=4016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=4016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=4016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}