{"id":6112,"date":"2024-04-26T10:17:56","date_gmt":"2024-04-26T08:17:56","guid":{"rendered":"https:\/\/www.nicalia.com\/nicapedia\/guias\/cpanel\/conceder-acceso-remoto-a-mysql\/"},"modified":"2025-08-27T17:18:09","modified_gmt":"2025-08-27T15:18:09","slug":"conceder-acceso-remoto-a-mysql","status":"publish","type":"docs","link":"https:\/\/www.nicalia.com\/nicapedia\/conceder-acceso-remoto-a-mysql\/","title":{"rendered":"Conceder acceso remoto a MySQL"},"content":{"rendered":"\n<p>Por seguridad, el acceso remoto a las bases de datos est\u00e1 inhabilitado pero es posible habilitarlo desde cPanel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"ConcederaccesoremotoaMySQL-\u00bfC\u00f3moconcederaccesoremotoaMySQL?\">\u00bfC\u00f3mo conceder acceso remoto a MySQL?<\/h3>\n\n\n\n<p>1. Accede a tu cuenta cPanel&nbsp;\u2192&nbsp; MySQL remoto (Remote MySQL)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"991\" height=\"249\" src=\"https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/24952555.png\" alt=\"\" class=\"wp-image-7880\" srcset=\"https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/24952555.png 991w, https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/24952555-300x75.png 300w, https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/24952555-768x193.png 768w\" sizes=\"(max-width: 991px) 100vw, 991px\" \/><\/figure>\n\n\n\n<p>2. Una vez accedas, observar\u00e1s dos campos para rellenar,&nbsp;<strong>Host&nbsp;<\/strong>y&nbsp;<strong>Comment<\/strong>. En Host debes indicar la IP que se va a conectar de forma remota a la base de datos y en Comment puedes a\u00f1adir alg\u00fan comentario para identificar esta conexi\u00f3n.&nbsp;<br>Puedes utilizar el comod\u00edn&nbsp;<strong>&#8220;%&#8221;<\/strong>&nbsp;para permitir todo tipo de conexiones (no recomendable).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/18154348-1024x396.png\" alt=\"\" class=\"wp-image-7881\" srcset=\"https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/18154348-1024x396.png 1024w, https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/18154348-300x116.png 300w, https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/18154348-768x297.png 768w, https:\/\/www.nicalia.com\/nicapedia\/wp-content\/uploads\/2024\/06\/18154348.png 1482w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><img decoding=\"async\" width=\"950\" src=\"https:\/\/wiki.nicalia.com\/download\/attachments\/18154346\/image2021-6-17_16-9-51.png?version=1&amp;modificationDate=1629832953200&amp;api=v2\" alt=\"\"><br>Con esto ya estar\u00eda concedido el acceso remoto a las bases de datos desde la IP que indicaste.<\/p>\n\n\n\n<p><a href=\"https:\/\/wiki.nicalia.com\/display\/WIKI\/Conceder+acceso+remoto+a+MySQL\" target=\"_blank\" rel=\"noopener\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Por seguridad, el acceso remoto a las bases de datos est\u00e1 inhabilitado pero es posible habilitarlo desde cPanel. \u00bfC\u00f3mo conceder acceso remoto a MySQL? 1. Accede a tu cuenta cPanel&nbsp;\u2192&nbsp; MySQL remoto (Remote MySQL) 2. Una vez accedas, observar\u00e1s dos campos para rellenar,&nbsp;Host&nbsp;y&nbsp;Comment. En Host debes indicar la IP que se va a conectar de [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":8644,"menu_order":28,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"doc_badge":[],"class_list":["post-6112","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/docs\/6112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/comments?post=6112"}],"version-history":[{"count":5,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/docs\/6112\/revisions"}],"predecessor-version":[{"id":8895,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/docs\/6112\/revisions\/8895"}],"up":[{"embeddable":true,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/docs\/8644"}],"wp:attachment":[{"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/media?parent=6112"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/doc_tag?post=6112"},{"taxonomy":"doc_badge","embeddable":true,"href":"https:\/\/www.nicalia.com\/nicapedia\/wp-json\/wp\/v2\/doc_badge?post=6112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}