{"id":7819,"date":"2025-08-26T13:34:08","date_gmt":"2025-08-26T16:34:08","guid":{"rendered":"https:\/\/king.host\/wiki\/?post_type=article&#038;p=7819"},"modified":"2025-08-26T13:34:09","modified_gmt":"2025-08-26T16:34:09","slug":"como-criar-usuario-adicional-para-mysql","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/como-criar-usuario-adicional-para-mysql\/","title":{"rendered":"Como Criar usu\u00e1rio adicional para Mysql"},"content":{"rendered":"\n<p>Usu\u00e1rios adicionais permitem acesso alternativo \u00e0 base de dados com permiss\u00f5es distintas em rela\u00e7\u00e3o ao usu\u00e1rio principal do banco. Portanto, veja neste artigo como \u00e9 simples criar usu\u00e1rio adicional para <a rel=\"noreferrer noopener\" aria-label=\"Mysql (abre numa nova aba)\" href=\"https:\/\/www.mysql.com\/\" target=\"_blank\">Mysql<\/a> atrav\u00e9s do <a rel=\"noreferrer noopener\" aria-label=\"painel de controle da KingHost (abre numa nova aba)\" href=\"https:\/\/king.host\/wiki\/artigo\/acessar-painel-de-controle-kinghost\/\" target=\"_blank\">painel de controle da KingHost<\/a>. \ud83d\ude00<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Como_Criar_usuario_adicional_para_Mysql\"><\/span>Como Criar usu\u00e1rio adicional para Mysql<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Em princ\u00edpio, logado no painel de controle, acesse a \u00e1rea referente ao gerenciamento do banco Mysql.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/001-3.png\" alt=\"Criar usu\u00e1rio adicional para Mysql\" class=\"wp-image-7820\"\/><\/figure><\/div>\n\n\n<p>Em seguida, utilize a op\u00e7\u00e3o de &#8220;<strong>Editar -&gt; Gerenciar Usu\u00e1rios<\/strong>&#8221; na base de dados que quer adicionar o novo usu\u00e1rio.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"415\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2.png\" alt=\"Criar usu\u00e1rio adicional para Mysql\" class=\"wp-image-7821 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2-300x162.png 300w\" data-sizes=\"(max-width: 768px) 100vw, 768px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 768px; --smush-placeholder-aspect-ratio: 768\/415;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"415\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2.png\" alt=\"Criar usu\u00e1rio adicional para Mysql\" class=\"wp-image-7821\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/002-2-300x162.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/noscript><\/figure><\/div>\n\n\n<p>Ent\u00e3o, ir\u00e1 abrir uma nova p\u00e1gina onde \u00e9 listado os usu\u00e1rios adicionais, ao lado direito, clique no bot\u00e3o de criar usu\u00e1rio adicional para Mysql.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"225\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3.png\" alt=\"Criar usu\u00e1rio adicional para Mysql\" class=\"wp-image-7822 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3.png 800w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3-300x84.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3-768x216.png 768w\" data-sizes=\"(max-width: 800px) 100vw, 800px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 800px; --smush-placeholder-aspect-ratio: 800\/225;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"225\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3.png\" alt=\"Criar usu\u00e1rio adicional para Mysql\" class=\"wp-image-7822\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3.png 800w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3-300x84.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/003-3-768x216.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/noscript><\/figure><\/div>\n\n\n<p>Dessa forma, surgir\u00e1 uma nova janela. Nela, defina a senha da base de dados, insira uma observa\u00e7\u00e3o se desejar e tamb\u00e9m defina o n\u00edvel de acesso por IP.<br>Para entender melhor, veja o descritivo abaixo da imagem.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"880\" height=\"535\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2.png\" alt=\"\" class=\"wp-image-7823 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2.png 880w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2-300x182.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2-768x467.png 768w\" data-sizes=\"(max-width: 880px) 100vw, 880px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 880px; --smush-placeholder-aspect-ratio: 880\/535;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"880\" height=\"535\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2.png\" alt=\"\" class=\"wp-image-7823\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2.png 880w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2-300x182.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/004-2-768x467.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/noscript><\/figure><\/div>\n\n\n<div class=\"bloco-info\"><strong>N\u00e3o liberar acesso externo<\/strong> &#8211; Neste modo, o acesso \u00e9 liberado somente para o servidor web relacionado ao banco de dados. \u00c9 o m\u00e9todo mais seguro e recomendado.<strong><br>Liberar acesso de qualquer IP<\/strong> &#8211; \u00c9 o m\u00e9todo mais inseguro, qualquer IP de qualquer lugar ou software consegue acessar a base.<br><strong>Liberar acesso apenas dos seguintes IPs<\/strong> &#8211; Se voc\u00ea pretende acessar sua base de dados atrav\u00e9s de uma aplicativo, o m\u00e9todo mais indicado \u00e9 usar esta op\u00e7\u00e3o e liberar apenas os IPs que far\u00e3o acesso a base (os IPs da sua rede).<br><strong>Permiss\u00f5es<\/strong> &#8211; Neste campo voc\u00ea escolhe quais permiss\u00f5es de manipula\u00e7\u00e3o ao banco de dados ter\u00e1 este usu\u00e1rio.<\/div>\n\n\n\n<p>Para finalizar a cria\u00e7\u00e3o da base, clique no bot\u00e3o <span class=\"button is-success\">CRIAR USU\u00c1RIO<\/span>.<\/p>\n\n\n\n<p>Por fim, \u00e9 disponibilizada a op\u00e7\u00e3o de editar um usu\u00e1rio j\u00e1 criado.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"346\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1.png\" alt=\"\" class=\"wp-image-7824 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1.png 783w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1-300x133.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1-768x339.png 768w\" data-sizes=\"(max-width: 783px) 100vw, 783px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 783px; --smush-placeholder-aspect-ratio: 783\/346;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"346\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1.png\" alt=\"\" class=\"wp-image-7824\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1.png 783w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1-300x133.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/06\/005-1-768x339.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/noscript><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Limitacoes\"><\/span>Limita\u00e7\u00f5es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul>\n<li><strong>Usu\u00e1rios adicionais podem acessar o banco de dados<\/strong> por meio do phpMyAdmin, SSH, MySQL Workbench e outras ferramentas.<\/li>\n\n\n\n<li>O nome de usu\u00e1rio possui um padr\u00e3o, n\u00e3o pode ser definido\/alterado pelo usu\u00e1rio. <strong>Cada banco pode ter um m\u00e1ximo de 5 usu\u00e1rios adicionais<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[176],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/7819"}],"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=7819"}],"version-history":[{"count":4,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/7819\/revisions"}],"predecessor-version":[{"id":26841,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/7819\/revisions\/26841"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=7819"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=7819"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=7819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}