{"id":955,"date":"2023-12-11T16:35:01","date_gmt":"2023-12-11T15:35:01","guid":{"rendered":"https:\/\/bretterhofer.at\/blog\/2023\/12\/dual-stack-defined-at-mariadb-list-of-ip-needed\/"},"modified":"2023-12-11T16:35:01","modified_gmt":"2023-12-11T15:35:01","slug":"dual-stack-defined-at-mariadb-list-of-ip-needed","status":"publish","type":"post","link":"https:\/\/bretterhofer.at\/blog\/2023\/12\/dual-stack-defined-at-mariadb-list-of-ip-needed\/","title":{"rendered":"Dual stack defined at mariadb list of IP needed"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"bind_address\"><code>nd_address<\/code><\/h4>\n\n\n\n<ul>\n<li><strong>Description:<\/strong> By default, the MariaDB server listens for TCP\/IP connections on all addresses. You can specify an alternative when the server starts using this option; either a host name, an IPv4 or an IPv6 address, &#8220;::&#8221; or &#8220;*&#8221; (all addresses). In some systems, such as Debian and Ubuntu, the bind_address is set to 127.0.0.1, which binds the server to listen on localhost only. <code>bind_address<\/code> has always been available as a <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadbd-options\/\">mariadbd option<\/a>; from <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1033-release-notes\/\">MariaDB 10.3.3<\/a> its also available as a system variable. Before <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1060-release-notes\/\">MariaDB 10.6.0<\/a> &#8220;::&#8221; implied listening additionally on IPv4 addresses like &#8220;*&#8221;. From 10.6.0 onwards it refers to IPv6 stictly. Starting with <a href=\"https:\/\/mariadb.com\/kb\/en\/what-is-mariadb-1011\/\">MariaDB 10.11<\/a>, a comma-separated list of addresses to bind to can be given. See also <a href=\"https:\/\/mariadb.com\/kb\/en\/configuring-mariadb-for-remote-client-access\/\">Configuring MariaDB for Remote Client Access<\/a>.<\/li>\n\n\n\n<li><strong>Commandline:<\/strong> <code class=\"fixed\">--bind-address=addr<\/code><\/li>\n\n\n\n<li><strong>Scope:<\/strong> Global<\/li>\n\n\n\n<li><strong>Dynamic:<\/strong> No<\/li>\n\n\n\n<li><strong>Data Type:<\/strong> <code>string<\/code><\/li>\n\n\n\n<li><strong>Default Value:<\/strong> (Empty string)<\/li>\n\n\n\n<li><strong>Valid Values:<\/strong> Host name, IPv4, IPv6, ::, *<\/li>\n\n\n\n<li><strong>Introduced:<\/strong> <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1033-release-notes\/\">MariaDB 10.3.3<\/a> (as a system variable)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>nd_address<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/posts\/955"}],"collection":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/comments?post=955"}],"version-history":[{"count":0,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/posts\/955\/revisions"}],"wp:attachment":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/media?parent=955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/categories?post=955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/tags?post=955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}