{"id":89,"date":"2023-10-26T19:09:46","date_gmt":"2023-10-27T01:09:46","guid":{"rendered":"http:\/\/knowledge.balamsoftware.net:8060\/?p=89"},"modified":"2023-10-26T19:09:47","modified_gmt":"2023-10-27T01:09:47","slug":"configurar-acceso-remoto-a-mysql-ubuntu","status":"publish","type":"post","link":"https:\/\/knowledge.balamsoftware.net\/?p=89","title":{"rendered":"Configurar acceso remoto a MySQL &#8211; Ubuntu"},"content":{"rendered":"\n<p>Modificar el archivo de configuraci\u00f3n de MySQL:<\/p>\n\n\n\n<p>sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"423\" src=\"http:\/\/knowledge.balamsoftware.net:8060\/wp-content\/uploads\/2023\/10\/image-17.png\" alt=\"\" class=\"wp-image-90\" srcset=\"https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-17.png 727w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-17-300x175.png 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<p>Buscaremos las siguientes l\u00edneas y se descimentar\u00e1n en caso de estar comentadas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>skip-external-locking<\/li>\n\n\n\n<li>bind-address = 127.0.0.1<\/li>\n\n\n\n<li>*En caso que no est\u00e9n estas l\u00edneas solo esribirlas \u201cbind-address = 127.0.0.1\u201d<\/li>\n<\/ul>\n\n\n\n<p>La IP que le vamos a dar a&nbsp;<strong>bind-address<\/strong>&nbsp;ser\u00e1&nbsp;<strong>0.0.0.0<\/strong>. En caso de que teng\u00e1is una IP espec\u00edfica a la que quer\u00e1is dar acceso, simplemente ponedla.<\/p>\n\n\n\n<p>Guardar cambios en el archivo y salir.<\/p>\n\n\n\n<p>Reiniciar el servicio para que las configuraciones tengan efecto.<\/p>\n\n\n\n<p>$ sudo service mysql restart<\/p>\n\n\n\n<p><strong>ngresar a MySQL<\/strong><\/p>\n\n\n\n<p>$ sudo mysql<\/p>\n\n\n\n<p>MySQL> CREATE USER &#8216;admin&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;Shotgun21_&#8217;;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"307\" src=\"http:\/\/knowledge.balamsoftware.net:8060\/wp-content\/uploads\/2023\/10\/image-18.png\" alt=\"\" class=\"wp-image-91\" srcset=\"https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-18.png 639w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-18-300x144.png 300w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><\/figure>\n\n\n\n<p>MySQL> GRANT ALL PRIVILEGES ON *.* TO admin@&#8217;%&#8217;;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"331\" src=\"http:\/\/knowledge.balamsoftware.net:8060\/wp-content\/uploads\/2023\/10\/image-19.png\" alt=\"\" class=\"wp-image-92\" srcset=\"https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-19.png 654w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-19-300x152.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<p>MySQL> FLUSH PRIVILEGES;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"424\" src=\"http:\/\/knowledge.balamsoftware.net:8060\/wp-content\/uploads\/2023\/10\/image-20.png\" alt=\"\" class=\"wp-image-93\" srcset=\"https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-20.png 638w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-20-300x199.png 300w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-20-310x205.png 310w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/figure>\n\n\n\n<p>exit;<\/p>\n\n\n\n<p>Abrir puerto en Firewall: 3306<\/p>\n\n\n\n<p>Reiniciar el servicio del firewall<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"139\" src=\"http:\/\/knowledge.balamsoftware.net:8060\/wp-content\/uploads\/2023\/10\/image-21.png\" alt=\"\" class=\"wp-image-94\" srcset=\"https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-21.png 599w, https:\/\/knowledge.balamsoftware.net\/wp-content\/uploads\/2023\/10\/image-21-300x70.png 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Modificar el archivo de configuraci\u00f3n de MySQL: sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf Buscaremos las siguientes l\u00edneas y se descimentar\u00e1n en caso de estar comentadas: skip-external-locking bind-address = 127.0.0.1 *En caso que no est\u00e9n estas l\u00edneas solo esribirlas \u201cbind-address = 127.0.0.1\u201d La IP que le vamos a dar a&nbsp;bind-address&nbsp;ser\u00e1&nbsp;0.0.0.0. En caso de que teng\u00e1is una IP espec\u00edfica a &hellip;<\/p>\n","protected":false},"author":1,"featured_media":95,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-89","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-servidores_linux"],"_links":{"self":[{"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=89"}],"version-history":[{"count":1,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":96,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/posts\/89\/revisions\/96"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=\/wp\/v2\/media\/95"}],"wp:attachment":[{"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/knowledge.balamsoftware.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}