{"id":6875,"date":"2017-07-21T16:05:28","date_gmt":"2017-07-21T08:05:28","guid":{"rendered":"http:\/\/rmohan.com\/?p=6875"},"modified":"2017-07-21T16:05:28","modified_gmt":"2017-07-21T08:05:28","slug":"mysql-5-7-forget-the-root-password","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6875","title":{"rendered":"MySQL 5.7 forget the root password"},"content":{"rendered":"

surroundings<\/strong><\/p>\n

CentOS<\/a>\u00a06.6 X86_64<\/p>\n

background<\/strong><\/p>\n

Forget how to do root, forget to initialize MySQL generated when the random password how to do, or simply did not register that random password, do not tell me to clear all the data under data, reinitialize, of course, you have to be so wayward can also be.
\nDo not pull, the following is the title.<\/p>\n

reference<\/strong><\/p>\n

Http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/resetting-permissions.html<\/a><\/p>\n

operating<\/strong><\/p>\n

There are several ways in the official document, I read the next, you remember the following I said a bar, the other you try it, so good to make me no matter<\/p>\n

Use –skip-grant-tables to start mysql server
\nbin \/ mysqld_safe –user = mysql01 –skip-grant-tables – skip-networking &<\/p>\n

Two options are meaning –
\nskip-grant-tables skip authorization –
\nskip-networking does not allow remote network connection<\/p>\n

Skip-networking can not, to prevent other users to connect the remote operation of the database, do not look at the actual situation.\u00a0Just learn an option.<\/p>\n

Client login
\nbin \/ mysql -uroot -p
\nupdate mysql.user set authentication_string = password (‘root’), password_expired = ‘N’ where user = ‘root’;
\nflush privileges;<\/p>\n

Change the password if you still remember ALTER USER ‘root’ @ ‘localhost’ IDENTIFIED BY ‘root’;
\nit is best not to use, it may prompt anonymous users do not allow to change the password and the like.<\/p>\n

Description<\/strong><\/p>\n

All relevant directories, links, parameters, etc., please adjust according to the actual situation.<\/p>\n","protected":false},"excerpt":{"rendered":"

surroundings<\/p>\n

CentOS 6.6 X86_64<\/p>\n

background<\/p>\n

Forget how to do root, forget to initialize MySQL generated when the random password how to do, or simply did not register that random password, do not tell me to clear all the data under data, reinitialize, of course, you have to be so wayward can also be. Do not […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6875"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6875"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6875\/revisions"}],"predecessor-version":[{"id":6876,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6875\/revisions\/6876"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}