{"id":5222,"date":"2018-07-20T12:44:12","date_gmt":"2018-07-20T15:44:12","guid":{"rendered":"http:\/\/wiki3.locaweb.com.br\/?post_type=ht_kb&#038;p=5222"},"modified":"2024-05-24T11:12:22","modified_gmt":"2024-05-24T14:12:22","slug":"conectar-remotamente-no-mysql-revenda-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/conectar-remotamente-no-mysql-revenda-cpanel\/","title":{"rendered":"Como conectar remotamente no MySQL &#8211; Revenda cPanel Shared \/ VPS"},"content":{"rendered":"    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Informa\u00e7\u00e3o<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tCaso esteja tentando conectar com seu banco de dados e n\u00e3o esteja conseguindo, \u00e9 necess\u00e1rio liberar o acesso, conforme o passo a passo abaixo.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n    \t\t<div class=\"hts-toggle  \"  >\r\n    \t\t\t<div class=\"hts-toggle__title\">Habilitando o MySQL remoto<\/div>\r\n    \t\t\t<div class=\"hts-toggle__content\">\r\n    \t\t\t\t<div class=\"hts-toggle__contentwrap\">\r\n    \t\t\t\t\t<\/p>\n<ul>\n<li>Acesse o <strong>painel cPanel\u00a0<\/strong>do dom\u00ednio.<\/li>\n<li>Localize o bloco <strong>&#8220;<\/strong><strong>Banco de Dados&#8221;<\/strong> e clique no bot\u00e3o <strong>&#8220;<\/strong><strong>MySQL remoto&#8221;<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5223\" src=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01.png\" alt=\"\" width=\"887\" height=\"126\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01.png 887w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01-300x43.png 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01-768x109.png 768w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01-50x7.png 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01-60x9.png 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-01-100x14.png 100w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><\/p>\n<ul>\n<li>Informe o <strong>IP <\/strong>que ir\u00e1 realizar a conex\u00e3o\u00a0ou para habilitar para <strong>todos os IPs<\/strong> coloque o simbolo<strong> %<\/strong>, ele ser\u00e1 um coringa.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5224\" src=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02.png\" alt=\"\" width=\"441\" height=\"165\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02.png 441w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02-300x112.png 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02-50x19.png 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02-60x22.png 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-02-100x37.png 100w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/p>\n<p>Depois de validar as informa\u00e7\u00f5es, clique no bot\u00e3o <strong>&#8220;<\/strong><strong>Adicionar host&#8221;<\/strong>.<\/p>\n<p>\n    \t\t\t\t<\/div>\r\n    \t\t\t<\/div><!-- \/ht-toggle-content -->\r\n    \t\t<\/div>\r\n    \t\t\n    \t\t<div class=\"hts-toggle  \"  >\r\n    \t\t\t<div class=\"hts-toggle__title\">Removendo o MySQL remoto<\/div>\r\n    \t\t\t<div class=\"hts-toggle__content\">\r\n    \t\t\t\t<div class=\"hts-toggle__contentwrap\">\r\n    \t\t\t\t\t<\/p>\n<ul>\n<li>Acesse o <strong>painel cPanel\u00a0<\/strong>do dom\u00ednio.<\/li>\n<li>Localize o bloco <strong>Banco de Dados<\/strong>\u00a0e clique no bot\u00e3o <strong>&#8220;<\/strong><strong>MySQL remoto&#8221;<\/strong>.<\/li>\n<li>Depois clique no bot\u00e3o <strong>&#8220;<\/strong><strong>Excluir&#8221;<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5226\" src=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03.png\" alt=\"\" width=\"371\" height=\"312\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03.png 371w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03-300x252.png 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03-50x42.png 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03-60x50.png 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/07\/Conectar-remotamente-no-MySQL-Revenda-cPanel-03-100x84.png 100w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/p>\n<ul>\n<li>Confirme a opera\u00e7\u00e3o e pronto, voc\u00ea removeu seu MySQL remoto.<\/li>\n<\/ul>\n<p>\n    \t\t\t\t<\/div>\r\n    \t\t\t<\/div><!-- \/ht-toggle-content -->\r\n    \t\t<\/div>\r\n    \t\t\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Conhe\u00e7a!<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAproveite e conhe\u00e7a outros produtos da Locaweb, como o servi\u00e7o <a href=\"https:\/\/www.locaweb.com.br\/cloud\" target=\"_blank\" rel=\"noopener\">Cloud Hosting<\/a>. Conhe\u00e7a tamb\u00e9m o <a class=\"waffle-rich-text-link\" href=\"https:\/\/www.locaweb.com.br\/servidor-vps\/\" target=\"_blank\" rel=\"noopener\">VPS<\/a> com a flexibilidade e autonomia que voc\u00ea precisa!\u00a0    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[111,424],"ht-kb-tag":[367,497],"class_list":["post-5222","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-revenda-cpanel","ht_kb_category-vps-cpanel","ht_kb_tag-categoriarevenda-cpanel","ht_kb_tag-categoriavps-cpanel"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/5222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=5222"}],"version-history":[{"count":12,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/5222\/revisions"}],"predecessor-version":[{"id":35312,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/5222\/revisions\/35312"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=5222"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=5222"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=5222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}