{"id":513,"date":"2025-08-27T02:42:29","date_gmt":"2025-08-27T05:42:29","guid":{"rendered":"https:\/\/www.kinghost.com.br\/wiki\/?post_type=article&#038;p=513"},"modified":"2025-08-27T02:42:29","modified_gmt":"2025-08-27T05:42:29","slug":"liberar-acesso-externo-mysql","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/liberar-acesso-externo-mysql\/","title":{"rendered":"Como liberar acesso externo para um banco de dados MySQL"},"content":{"rendered":"\n<p>Precisa liberar acesso externo para um banco de dados MySQL para acess\u00e1-lo por aplicativos? Abaixo voc\u00ea pode ver com isso pode ser feito atrav\u00e9s do Painel de Controle.<br><strong>Importante<\/strong>: Bancos de dados Firebird, Postgre, MongoDB e MSSQL Server j\u00e1 possuem o acesso externo liberado.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Liberar_acesso_para_um_banco_de_dados_MySQL\"><\/span>Liberar acesso para um banco de dados MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A libera\u00e7\u00e3o de acesso externo pode ser feita atrav\u00e9s do <a href=\"https:\/\/painel.kinghost.com.br\/\" target=\"_blank\" rel=\"noopener\">Painel de Controle<\/a>.<br>Acesse o Painel de Controle, selecione o seu dom\u00ednio e navegue at\u00e9 a se\u00e7\u00e3o <strong>Banco de dados<\/strong>.<br>Clique em <strong>Gerenciar bancos MySQL<\/strong>.<br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2015\/03\/gerenciar-bancos001.png\"><img data-original=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2015\/03\/gerenciar-bancos001.png\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Liberar_acesso_para_IP_especifico\"><\/span>Liberar acesso para IP espec\u00edfico<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Na listagem de bancos, identifique o banco que deseja liberar acesso externo e clique em <strong>Editar<\/strong>.<br>Depois clique em <strong>Gerenciar Acesso Externo<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"430\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79.png\" alt=\"\" class=\"wp-image-24489 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79.png 762w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79-300x169.png 300w\" data-sizes=\"(max-width: 762px) 100vw, 762px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 762px; --smush-placeholder-aspect-ratio: 762\/430;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"430\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79.png\" alt=\"\" class=\"wp-image-24489\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79.png 762w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-79-300x169.png 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/noscript><\/figure><\/div>\n\n\n<p>Na tela que surgir marque a terceira op\u00e7\u00e3o: <strong>Liberar acesso apenas dos seguintes IPs<\/strong>.<br>Logo em seguida, no campo que surgir, insira o IP que deseja liberar acesso. Precisa saber seu IP? Portanto, acesse: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/ip\/\">Descobrir endere\u00e7o IP<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"593\" height=\"470\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80.png\" alt=\"\" class=\"wp-image-24490 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80.png 593w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80-300x238.png 300w\" data-sizes=\"(max-width: 593px) 100vw, 593px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 593px; --smush-placeholder-aspect-ratio: 593\/470;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"593\" height=\"470\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80.png\" alt=\"\" class=\"wp-image-24490\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80.png 593w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-80-300x238.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/noscript><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Liberar_todos_os_IPs\"><\/span>Liberar todos os IPs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Para liberar qualquer endere\u00e7o IP, basta utilizar a op\u00e7\u00e3o <strong>Liberar acesso de qualquer IP<\/strong>.<br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"596\" height=\"374\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81.png\" alt=\"\" class=\"wp-image-24491 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81.png 596w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81-300x188.png 300w\" data-sizes=\"(max-width: 596px) 100vw, 596px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 596px; --smush-placeholder-aspect-ratio: 596\/374;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"596\" height=\"374\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81.png\" alt=\"\" class=\"wp-image-24491\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81.png 596w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-81-300x188.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/noscript><\/figure><\/div>\n\n\n<p>A libera\u00e7\u00e3o para todos os IPs facilita o processo se sua rede n\u00e3o tiver um IP est\u00e1tico. Dessa maneira, \u00e9 importante tomar cuidado com a seguran\u00e7a da sua base de dados.<\/p>\n\n\n\n<p>Libera\u00e7\u00e3o de IPs para uma base MySQL \u00e9 um tanto simples como voc\u00ea mesmo pode observar.<br><\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[11],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/513"}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":7,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/513\/revisions"}],"predecessor-version":[{"id":26941,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/513\/revisions\/26941"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=513"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}