{"id":531,"date":"2015-05-12T09:08:06","date_gmt":"2015-05-12T12:08:06","guid":{"rendered":"https:\/\/www.kinghost.com.br\/wiki\/?post_type=article&#038;p=531"},"modified":"2024-09-13T09:16:06","modified_gmt":"2024-09-13T12:16:06","slug":"dados-acesso-banco-de-dados","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/dados-acesso-banco-de-dados\/","title":{"rendered":"Onde encontrar os dados de acesso ao seu banco de dados"},"content":{"rendered":"\n<p>Voc\u00ea pode conferir os dados de acesso do seu banco de dados via Painel de Controle.<br> Acesse o <a rel=\"noopener noreferrer\" href=\"https:\/\/painel.kinghost.com.br\/\" target=\"_blank\">Painel de Controle da King<\/a> e selecione o seu dom\u00ednio.<br> Navegue at\u00e9 a se\u00e7\u00e3o <strong>Bancos de Dados<\/strong> e selecione o tipo de banco que utiliza (MySQL, Postgre ou outro).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/03\/gerenciar-bancos001.png\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/03\/gerenciar-bancos001.png\" alt=\"Painel de Controle KingHost - Gerenciar banco de dados\" class=\"wp-image-2156\"\/><\/a><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Verificar_nome_do_host_de_conexao\"><\/span>Verificar nome do host de conex\u00e3o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Assim que acessar a ferramenta, o primeiro quadro de informa\u00e7\u00f5es exibir\u00e1 o host principal e alternativo de acesso \u00e0 base. O host sempre segue um padr\u00e3o que \u00e9: <span class=\"kh-featured\"><strong>sgbd.seudominio<\/strong><\/span>.<br> <font color=\"#808080\">Exemplo: Caso seu dom\u00ednio seja tvplanet.org, o host para conex\u00e3o mysql ser\u00e1 mysql.tvplanet.org<\/font>.<br> <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"369\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67.png\" alt=\"\" class=\"wp-image-24459 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67.png 770w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67-300x144.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67-768x368.png 768w\" data-sizes=\"(max-width: 770px) 100vw, 770px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 770px; --smush-placeholder-aspect-ratio: 770\/369;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"369\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67.png\" alt=\"\" class=\"wp-image-24459\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67.png 770w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67-300x144.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2023\/11\/image-67-768x368.png 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/noscript><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"E_como_ficam_os_demais_SGBDs\"><\/span> E como ficam os demais SGBDs?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>SGBD<\/td><td>Padr\u00e3o do nome do host<\/td><td>Exemplo de uso<br><\/td><\/tr><tr><td>MySQL<\/td><td><strong>mysql<\/strong>.dominio<\/td><td>mysql.mecompany.net<\/td><\/tr><tr><td>Postgre<\/td><td><strong>pgsql<\/strong>.dominio<\/td><td>pgsql.construindopontes.net.br<\/td><\/tr><tr><td>Firebird<\/td><td><strong>firebird<\/strong>.dominio<\/td><td>firebird.guacameleeturbo.info<\/td><\/tr><tr><td>SQL Server<\/td><td><strong>mssql<\/strong>.dominio<\/td><td>mssql.listentothecore.biz<\/td><\/tr><tr><td>MongoDB<\/td><td><strong>mongodb<\/strong>.dominio<\/td><td>mongodb.walktheday.com.br<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Verificar_nome_do_banco_de_dados_usuario_e_senha\"><\/span>Verificar nome do banco de dados, usu\u00e1rio e senha<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Por padr\u00e3o, o nome do usu\u00e1rio <strong>sempre<\/strong> ser\u00e1 o mesmo nome da base de dados.<br>\n<font color=\"#808080\">Exemplo: Se o nome da base newmedia04, o nome do usu\u00e1rio tamb\u00e9m ser\u00e1 newmedia04<\/font>.<\/p>\n\n\n\n<p>A senha \u00e9 definida por voc\u00ea no momento da cria\u00e7\u00e3o do banco &#8211; Caso precise redefini-la, acesse este o artigo <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/como-alterar-a-senha-de-uma-base-de-dados\/\"><b>Alterar senha da base<\/b><\/a> para saber como.<\/p>\n\n\n\n<p>O nome do banco pode ser conferido na mesma ferramenta, na listagem de bancos.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/bd-bancosatuais.jpg\" alt=\"\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" class=\"lazyload\" style=\"--smush-placeholder-width: 795px; --smush-placeholder-aspect-ratio: 795\/250;\" \/><noscript><img decoding=\"async\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/bd-bancosatuais.jpg\" alt=\"\"\/><\/noscript><\/figure>\n\n\n\n<p>Conforme visto acima, atrav\u00e9s do nosso painel voc\u00ea consegue identificar todos os dados necess\u00e1rios para fazer acesso \u00e0 sua base de dados. Em suma, voc\u00ea pode usar estes dados de acesso em qualquer aplicativo de conex\u00e3o a bancos de dados. Contudo, voc\u00ea ir\u00e1 precisar liberar acesso ao banco para IPs externos, veja como fazer no post: <a href=\"https:\/\/king.host\/wiki\/artigo\/liberar-acesso-externo-para-um-banco-de-dados\/\" target=\"_blank\" rel=\"noopener noreferrer\">Como liberar acesso externo para uma base de dados<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/king.host\/?utm_source=wiki&amp;utm_medium=banner-artigo&amp;utm_campaign=banner-artigo-wiki-awareness-dados-acesso-banco-de-dados\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"250\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1.png\" alt=\"banner-kinghost\" class=\"wp-image-25436 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1.png 798w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1-300x94.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1-768x241.png 768w\" data-sizes=\"(max-width: 798px) 100vw, 798px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 798px; --smush-placeholder-aspect-ratio: 798\/250;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"250\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1.png\" alt=\"banner-kinghost\" class=\"wp-image-25436\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1.png 798w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1-300x94.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/05\/banner_1-768x241.png 768w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/figure>\n","protected":false},"author":9,"featured_media":0,"menu_order":6,"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\/531"}],"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=531"}],"version-history":[{"count":3,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/531\/revisions"}],"predecessor-version":[{"id":25452,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/531\/revisions\/25452"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=531"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=531"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}