{"id":7502,"date":"2018-11-16T09:40:54","date_gmt":"2018-11-16T08:40:54","guid":{"rendered":"https:\/\/blog.unelink.es\/?p=7502"},"modified":"2019-10-25T14:04:32","modified_gmt":"2019-10-25T12:04:32","slug":"permitir-el-acceso-remoto-a-una-base-de-datos-en-cpanel","status":"publish","type":"post","link":"https:\/\/hosting.airetech.es\/blog\/wiki\/permitir-el-acceso-remoto-a-una-base-de-datos-en-cpanel\/","title":{"rendered":"Permitir el acceso remoto a una base de datos en cPanel"},"content":{"rendered":"<p>Es posible que tengas la necesidad de <strong>acceder a una base de datos MySQL<\/strong> que tengas en tu servidor (<a href=\"https:\/\/www.unelink.es\/servidores-virtuales-33.html\" target=\"_blank\" rel=\"noopener noreferrer\">VPS<\/a> o <a href=\"https:\/\/www.unelink.es\/servidores-dedicados-32.html\" target=\"_blank\" rel=\"noopener noreferrer\">dedicado<\/a>) <strong>desde una IP externa<\/strong>. Ya sea porque tienes una aplicaci\u00f3n que utilice la informaci\u00f3n de esa base de datos o porque la web que se nutre de ella est\u00e9 en otro servidor.<\/p>\n<p>Desde cPanel puedes indicar IPs que pueden acceder a las bases de datos. Vamos a ver c\u00f3mo hacerlo.<\/p>\n<p>Lo primero de todo es <strong>acceder al cPanel de la cuenta<\/strong> donde est\u00e1 esa base de datos.<\/p>\n<div id=\"attachment_7503\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/acceso-cpanel-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7503\" class=\"size-full wp-image-7503\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/acceso-cpanel-1.jpg\" alt=\"Acceso cPanel\" width=\"304\" height=\"347\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/acceso-cpanel-1.jpg 304w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/acceso-cpanel-1-263x300.jpg 263w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/a><p id=\"caption-attachment-7503\" class=\"wp-caption-text\">Acceso cPanel<\/p><\/div>\n<p>En la pantalla principal haz clic en <strong>MySQL Remoto<\/strong>, dentro de la secci\u00f3n Bases de datos.<\/p>\n<div id=\"attachment_7504\" style=\"width: 661px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7504\" class=\" wp-image-7504\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos.jpg\" alt=\"Herramientas bases de datos\" width=\"651\" height=\"243\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos.jpg 821w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos-300x112.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos-768x286.jpg 768w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/bases-de-datos-600x224.jpg 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/a><p id=\"caption-attachment-7504\" class=\"wp-caption-text\">Herramientas bases de datos<\/p><\/div>\n<p><strong>Indica la IP<\/strong> a la que quieres permitir el acceso y pulsa el bot\u00f3n <strong>A\u00f1adir anfitri\u00f3n.<\/strong><\/p>\n<div id=\"attachment_7505\" style=\"width: 661px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7505\" class=\" wp-image-7505\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip.jpg\" alt=\"A\u00f1adir IP\" width=\"651\" height=\"312\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip.jpg 858w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip-300x144.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip-768x369.jpg 768w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/anadir-ip-600x288.jpg 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/a><p id=\"caption-attachment-7505\" class=\"wp-caption-text\">A\u00f1adir IP<\/p><\/div>\n<p>Se a\u00f1adir\u00e1 la IP y <strong>ya podr\u00e1s acceder a la base de datos desde ella<\/strong>.<\/p>\n<div id=\"attachment_7506\" style=\"width: 873px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7506\" class=\"size-full wp-image-7506\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas.jpg\" alt=\"IPs a\u00f1adidas\" width=\"863\" height=\"158\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas.jpg 863w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas-300x55.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas-768x141.jpg 768w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/11\/ip-anadidas-600x110.jpg 600w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><\/a><p id=\"caption-attachment-7506\" class=\"wp-caption-text\">IPs a\u00f1adidas<\/p><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"Es posible que tengas la necesidad de acceder a una base de datos MySQL que tengas en tu servidor (VPS o dedicado) desde una IP externa. Ya sea porque tienes una aplicaci\u00f3n que utilice la informaci\u00f3n de esa base de datos o porque la web que se nutre de ella est\u00e9 en otro servidor. Desde cPanel puedes indicar IPs que&nbsp;<a href=\"https:\/\/hosting.airetech.es\/blog\/wiki\/permitir-el-acceso-remoto-a-una-base-de-datos-en-cpanel\/\" class=\"read-more\">Seguir leyendo<\/a>","protected":false},"author":1,"featured_media":7506,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[457,12,121,6],"tags":[224,68,20],"class_list":["post-7502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos-panel-cpanel","category-bases-de-datos","category-panel-cpanel","category-wiki","tag-bases-de-datos","tag-cpanel","tag-mysql","cat-457-id","cat-12-id","cat-121-id","cat-6-id"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/7502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/comments?post=7502"}],"version-history":[{"count":3,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/7502\/revisions"}],"predecessor-version":[{"id":8844,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/7502\/revisions\/8844"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media\/7506"}],"wp:attachment":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media?parent=7502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/categories?post=7502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/tags?post=7502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}