{"id":656,"date":"2022-09-21T15:07:27","date_gmt":"2022-09-21T18:07:27","guid":{"rendered":"https:\/\/blog.init.net.br\/?p=656"},"modified":"2022-09-21T15:07:52","modified_gmt":"2022-09-21T18:07:52","slug":"alterar-senha-de-root-mysql-ubuntu","status":"publish","type":"post","link":"https:\/\/blog.init.net.br\/?p=656","title":{"rendered":"Alterar senha de root mysql (Ubuntu)"},"content":{"rendered":"\n<p>Caso tenha esquecido a senha de root do Mysql, \u00e9 poss\u00edvel alterar a senha \u00e0 partir da console.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>1 &#8211; Parar o servi\u00e7o do mysql:<\/strong><\/p>\n\n\n\n<p><code>sudo systemctl stop mysql<\/code><\/p>\n\n\n\n<p><strong>2 &#8211; Inicie o sistema em modo seguro:<\/strong><\/p>\n\n\n\n<p><code>mysqld_safe --skip-grant-tables &amp;<\/code><\/p>\n\n\n\n<p>Dever\u00e1 retornar os seguintes avisos:<br><code>2022-09-21T07:14:43.206936Z mysqld_safe Logging to syslog.<br>220921 14:02:15 mysqld_safe Logging to '\/var\/log\/mysql\/error.log'.<br>220921 14:02:15 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/code><\/p>\n\n\n\n<p><strong>3 &#8211; Fa\u00e7a o login como root e altere a senha:<\/strong><\/p>\n\n\n\n<p><code>mysql -u root<\/code><br><code>use mysql;<\/code><br><code>update user set password=PASSWORD(\"novasenha\") where User='root';<\/code><br><code>flush privileges;<\/code><br><code>quit<\/code><\/p>\n\n\n\n<p> <strong>4 &#8211; Parar e iniciar o servi\u00e7o novamente:<\/strong><\/p>\n\n\n\n<p><code>sudo systemctl stop mysql<\/code><br><code>sudo systemctl start mysql<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Caso tenha esquecido a senha de root do Mysql, \u00e9 poss\u00edvel alterar a senha \u00e0 partir da console. 1 &#8211; Parar o servi\u00e7o do mysql: sudo systemctl stop mysql 2 &#8211; Inicie o sistema em modo seguro: mysqld_safe &#8211;skip-grant-tables &amp; Dever\u00e1 retornar os seguintes avisos:2022-09-21T07:14:43.206936Z mysqld_safe Logging to syslog.220921 14:02:15 mysqld_safe Logging to &#8216;\/var\/log\/mysql\/error.log&#8217;.220921 14:02:15 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/posts\/656"}],"collection":[{"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=656"}],"version-history":[{"count":3,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/posts\/656\/revisions"}],"predecessor-version":[{"id":659,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=\/wp\/v2\/posts\/656\/revisions\/659"}],"wp:attachment":[{"href":"https:\/\/blog.init.net.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.init.net.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}