{"id":108,"date":"2022-08-08T07:36:16","date_gmt":"2022-08-08T07:36:16","guid":{"rendered":"https:\/\/www.wiseos.org\/?p=108"},"modified":"2022-08-08T07:36:18","modified_gmt":"2022-08-08T07:36:18","slug":"permitir-acceso-remoto-mariadb-debian-11","status":"publish","type":"post","link":"https:\/\/www.wiseos.org\/?p=108","title":{"rendered":"Permitir acceso Remoto MariaDB\/Debian 11"},"content":{"rendered":"<div class=\"entry\">\n\n\n<p>Para permitir acceso remoto a la Base de Datos MariaDB en Debian 11 hay que hacer 2 cosas. Primero permitir al servidor que se pueda acceder remotamente y despu\u00e9s crear un usuario con acceso remoto permitido.  <\/p>\n\n\n\n<p class=\"has-text-align-left\">Para lograrlo vamos a modificar el siguiente fichero: <em>\/etc\/mysql\/mariadb.conf.d\/50-server.conf<\/em>. <\/p>\n\n\n\n<p>Hemos de localizar la siguiente parte del fichero: <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"63\" src=\"https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen.png\" alt=\"\" class=\"wp-image-109\" srcset=\"https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen.png 547w, https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen-300x35.png 300w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/figure>\n\n\n\n<p>Y despu\u00e9s hemos de remplazarlo por:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"107\" src=\"https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen-1.png\" alt=\"\" class=\"wp-image-110\" srcset=\"https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen-1.png 555w, https:\/\/www.wiseos.org\/wp-content\/uploads\/2022\/08\/imagen-1-300x58.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n\n\n\n<p>Una vez modificado hemos de reiniciar el servicio MariaDB con el comando <em>\u00abservice mariadb restart\u00bb<\/em><\/p>\n\n\n\n<p>Despu\u00e9s hemos de dar acceso a un usuario para que pueda acceder desde cualquier Host de la red, para ello desde la terminal con el cliente de mariadb \u00ab<em>mysql\u00bb<\/em> escribimos el siguiente comando:<\/p>\n\n\n\n<pre class=\"wp-block-code has-cyan-bluish-gray-background-color has-background\"><code><strong>GRANT ALL PRIVILEGES ON <em>.<\/em> TO 'root'@'192.168.100.%'<br>IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;<\/strong><\/code><\/pre>\n\n\n\n<p>Con esto ya deber\u00edamos poder acceder desde cualquier host de nuestra red interna al servidor de base de datos MariaDB. <\/p>\n\n\n\n<p>Si necesitas mas informaci\u00f3n puedes visitar la web oficial de MariaDB <a href=\"https:\/\/mariadb.com\/kb\/en\/configuring-mariadb-for-remote-client-access\/\" data-type=\"URL\" data-id=\"https:\/\/mariadb.com\/kb\/en\/configuring-mariadb-for-remote-client-access\/\">https:\/\/mariadb.com\/kb\/en\/configuring-mariadb-for-remote-client-access\/<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Para permitir acceso remoto a la Base de Datos MariaDB en Debian 11 hay que hacer 2 cosas. Primero permitir al servidor que se pueda acceder remotamente y despu\u00e9s crear un usuario con acceso remoto permitido. Para lograrlo vamos a modificar el siguiente fichero: \/etc\/mysql\/mariadb.conf.d\/50-server.conf. Hemos de localizar la siguiente parte del fichero: Y despu\u00e9s &#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-108","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-sin-categoria","7":"anons"},"_links":{"self":[{"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=108"}],"version-history":[{"count":3,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":113,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=\/wp\/v2\/posts\/108\/revisions\/113"}],"wp:attachment":[{"href":"https:\/\/www.wiseos.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wiseos.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}