{"id":31978,"date":"2017-12-07T13:54:16","date_gmt":"2017-12-07T13:54:16","guid":{"rendered":"http:\/\/blogmed.antonini.psc.br\/?p=31978"},"modified":"2021-04-02T04:56:00","modified_gmt":"2021-04-02T04:56:00","slug":"criar-usuarios-no-mysql-e-mariadb","status":"publish","type":"post","link":"https:\/\/antonini.ddns.net\/?p=31978","title":{"rendered":"Criar usu\u00e1rios no Mysql e MariaDB"},"content":{"rendered":"<p>Primeiramente, entrar no servidor de bando de dados:<\/p>\n<p><em>mysql -u root -p<\/em><\/p>\n<p>depois colar:<\/p>\n<p><b><i># mysql -u USUARIO -p<\/i><\/b><\/p>\n<p><b><i>Enter password:<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400;\">Axecute os comandos abaixo para criar o usu\u00e1rio e senha, bem como defini\u00e7\u00e3o de privil\u00e9gios:<\/span><\/p>\n<p>Apenas localhost:<\/p>\n<p><b>CREATE USER &#8216;usuario&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;senha&#8217;;<\/b><br \/>\n   CREATE USER &#8216;usuario&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;password&#8217;;<\/p>\n<p><b>GRANT ALL PRIVILEGES ON *.* TO&#8217;usuario&#8217;@&#8217;localhost&#8217; WITH GRANT OPTION;<\/b><\/p>\n<p><strong>FLUSH PRIVILEGES;<\/strong><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">A linha 1. cria o usu\u00e1rio (com acesso permitido somente de localhost)e a senha de acesso.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">A linha 2. define as pol\u00edticas de acesso do usu\u00e1rio, nesse exemplo, o usu\u00e1rio tem permiss\u00e3o para acessar tudo e somente apartir de localhost.<\/span><\/li>\n<li>A linha tr\u00eas instala os privil\u00e9gios<\/li>\n<\/ul>\n<p>Acessar de qualquer lugar:<\/p>\n<p><strong>CREATE USER &#8216;usuario&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;senha&#8217;;<\/strong><br \/>\n<strong> GRANT ALL PRIVILEGES ON *.* TO &#8216;usuario&#8217;@&#8217;%&#8217; WITH GRANT OPTION;<\/strong><br \/>\n<strong>FLUSH PRIVILEGES;<\/strong><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">A linha 1. cria o usu\u00e1rio (para acesso de qualquer host) e a senha.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">A linha 2. nesse exemplo, o usu\u00e1rio tem permiss\u00e3o para acessar tudo apartir de qualquer host.<\/span><\/li>\n<li>A linha tr\u00eas instala os privil\u00e9gios<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\">[<a href=\"javascript:history.go(-1)\">Voltar<\/a>]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Primeiramente, entrar no servidor de bando de dados: mysql -u root -p depois colar: # mysql -u USUARIO -p Enter password: Axecute os comandos abaixo para criar o usu\u00e1rio e senha, bem como defini\u00e7\u00e3o de privil\u00e9gios: Apenas localhost: CREATE USER &#8216;usuario&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;senha&#8217;; CREATE USER &#8216;usuario&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;password&#8217;; GRANT ALL PRIVILEGES ON *.* [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-31978","post","type-post","status-publish","format-standard","hentry","category-informatica"],"_links":{"self":[{"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/31978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31978"}],"version-history":[{"count":5,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/31978\/revisions"}],"predecessor-version":[{"id":32088,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/31978\/revisions\/32088"}],"wp:attachment":[{"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/antonini.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}