{"id":2125,"date":"2019-03-02T22:34:45","date_gmt":"2019-03-03T04:34:45","guid":{"rendered":"http:\/\/linuxitos.com\/main\/?p=2125"},"modified":"2019-03-02T22:34:47","modified_gmt":"2019-03-03T04:34:47","slug":"administrar-phpmyadmin-remoto-con-servidor-en-fedora-29","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/administrar-phpmyadmin-remoto-con-servidor-en-fedora-29\/","title":{"rendered":"Administrar phpMyAdmin remoto con servidor en Fedora 29"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Screenshot-from-2019-03-02-21-04-36-1024x576.png\" alt=\"\" class=\"wp-image-2128\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Screenshot-from-2019-03-02-21-04-36-1024x576.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Screenshot-from-2019-03-02-21-04-36-300x169.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Screenshot-from-2019-03-02-21-04-36-768x432.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Screenshot-from-2019-03-02-21-04-36.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin es una herramienta de software libre escrita en PHP, destinada a manejar la administraci\u00f3n de MySQL sobre la Web. phpMyAdmin soporta una amplia gama de operaciones en MySQL y MariaDB. Las operaciones m\u00e1s frecuentes (gesti\u00f3n de bases de datos, tablas, columnas, relaciones, \u00edndices, usuarios, permisos, etc.) se pueden realizar a trav\u00e9s de la interfaz de usuario, mientras que todav\u00eda tiene la posibilidad de ejecutar directamente cualquier instrucci\u00f3n SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"text-align:right\"><a href=\"https:\/\/www.phpmyadmin.net\">https:\/\/www.phpmyadmin.net<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Por defecto al intentar acceder a la IP del equipo d\u00f3nde se encuentra instalado XAMPP y administrar phpMyAdmin de manera remota, marcar\u00e1 error de acceso, como se muestra en la imagen de abajo.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"522\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Captura-de-pantalla-3-1024x522.png\" alt=\"\" class=\"wp-image-2127\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Captura-de-pantalla-3-1024x522.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Captura-de-pantalla-3-300x153.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Captura-de-pantalla-3-768x391.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2019\/03\/Captura-de-pantalla-3.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Para corregir \u00e9ste problema, es necesario modificar el archivo httpd-xamp.conf<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo gedit \/opt\/lampp\/etc\/extra\/httpd-xampp.conf<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Abrir el documento, buscar la secci\u00f3n de c\u00f3digo que aparece abajo.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;Directory \"\/opt\/lampp\/phpmyadmin\">\n\tAllowOverride AuthConfig Limit\n\tRequire local\n\tErrorDocument 403 \/error\/XAMPP_FORBIDDEN.html.var\n&lt;\/Directory><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez encontrado al secci\u00f3n, modificarla para permitir cualquier conexi\u00f3n de cualquier ip de la red, o bien, especificar solo una ip:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># since XAMPP 1.4.3\n&lt;Directory \"\/opt\/lampp\/phpmyadmin\">\n\tAllowOverride AuthConfig Limit\n\t# Require local\n\t# Require ip 192.168.1.72\n\tRequire all granted\n\tErrorDocument 403 \/error\/XAMPP_FORBIDDEN.html.var\n&lt;\/Directory><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Y con eso ya se podr\u00e1 administrar de manera remota dentro de la misma red.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin es una herramienta de software libre escrita en PHP, destinada a manejar la administraci\u00f3n de MySQL sobre la Web. phpMyAdmin soporta una amplia gama de operaciones en MySQL y MariaDB. Las operaciones m\u00e1s frecuentes (gesti\u00f3n de bases de datos, tablas, columnas, relaciones, \u00edndices, usuarios, permisos, etc.) se pueden realizar a trav\u00e9s de la interfaz [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1569,10],"tags":[1601,1600],"class_list":["post-2125","post","type-post","status-publish","format-standard","hentry","category-fedora-29","category-xampp","tag-phpmyadmin","tag-xamppp"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=2125"}],"version-history":[{"count":2,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2125\/revisions"}],"predecessor-version":[{"id":2130,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2125\/revisions\/2130"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=2125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=2125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=2125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}