{"id":747,"date":"2021-06-22T00:08:48","date_gmt":"2021-06-22T00:08:48","guid":{"rendered":"https:\/\/asgardius.company\/?p=747"},"modified":"2021-06-22T00:08:48","modified_gmt":"2021-06-22T00:08:48","slug":"como-activar-el-acceso-remto-en-mariadb","status":"publish","type":"post","link":"https:\/\/asgardius.company\/?p=747","title":{"rendered":"C\u00f3mo activar el acceso remto en MariaDB"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/asgardius.company\/wp-content\/uploads\/2021\/06\/database-152091_960_720.png\" alt=\"\" class=\"wp-image-751\"\/><\/figure>\n\n\n\n<p>Para permitir conexiones remotas en el servidor MariaDB necesitamos editar el siguiente archivo<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/pre>\n\n\n\n<p>Buscamos la siguiente l\u00ednea<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bind-address            = 127.0.0.1<\/code><\/pre>\n\n\n\n<p>La dejamos as\u00ed<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bind-address            = *<\/code><\/pre>\n\n\n\n<p>Reiniciamos el servicio<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl restart mysql<\/code><\/pre>\n\n\n\n<p>En caso de usar Yunohost abrimos el puerto correspondiente a MySQL en el firewall con el siguiente comando<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo yunohost firewall allow TCP 3306<\/code><\/pre>\n\n\n\n<p>Yunohost no har\u00e1 copias de seguridad de las bases de datos creadas manualmente<\/p>\n\n\n\n<p>Referencias<\/p>\n\n\n\n<p><a href=\"https:\/\/linuxize.com\/post\/mysql-remote-access\/\">https:\/\/linuxize.com\/post\/mysql-remote-access\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para permitir conexiones remotas en el servidor MariaDB necesitamos editar el siguiente archivo Buscamos la siguiente l\u00ednea La dejamos as\u00ed Reiniciamos el servicio En caso de usar Yunohost abrimos el puerto correspondiente a MySQL en el firewall con el siguiente comando Yunohost no har\u00e1 copias de seguridad de las bases de datos creadas manualmente Referencias&hellip; <a class=\"more-link\" href=\"https:\/\/asgardius.company\/?p=747\">Seguir leyendo <span class=\"screen-reader-text\">C\u00f3mo activar el acceso remto en MariaDB<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-747","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/asgardius.company\/index.php?rest_route=\/wp\/v2\/posts\/747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asgardius.company\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asgardius.company\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asgardius.company\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/asgardius.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=747"}],"version-history":[{"count":0,"href":"https:\/\/asgardius.company\/index.php?rest_route=\/wp\/v2\/posts\/747\/revisions"}],"wp:attachment":[{"href":"https:\/\/asgardius.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asgardius.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asgardius.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}