\u5fd8\u8bb0\u5bc6\u7801\u91cd\u7f6e\uff1a<\/p>\n
cd \/etc<\/p>\n
vi my.cnf<\/p>\n
\u5728[mysqld] \u4e0b\u65b0\u589e\u4e00\u884c<\/p>\n
–skip-grant-tables<\/p>\n
\u91cd\u542fmysqld, systemctl restart mysqld<\/p>\n
<\/p>\n
mysql -h localhost -uroot<\/p>\n
mysql>use mysql;<\/p>\n
mysql>select plugin from user where user=’root’;<\/p>\n
mysql>update user set plugin=’mysql_native_password’;<\/p>\n
mysql>update user set authentication_string=password(‘123456′) where user=’root’ and host=’localhost’;<\/p>\n
mysql>flush privileges;<\/p>\n
\u5c06my.cnf\u4e2d\u65b0\u589e\u7684\u7684\u884c\uff0c\u5220\u9664<\/p>\n
\u91cd\u542fmysqld, systemctl restart mysqld<\/p>\n
\u641e\u5b9a\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5fd8\u8bb0\u5bc6\u7801\u91cd\u7f6e\uff1a cd \/etc vi my.cnf \u5728[mysqld] \u4e0b\u65b0\u589e\u4e00\u884c –skip-grant-tables \u91cd\u542fmysqld, systemctl restart mysqld mysql -h localhost -uroot mysql>use mysql; mysql>select plugin from user where user=’root’; mysql>update user set plugin=’mysql_native_password’; mysql>update user set authentication_string=password(‘123456′) where user=’root’ and host=’localhost’; mysql>flush privileges; \u5c06my.cnf\u4e2d\u65b0\u589e\u7684\u7684\u884c\uff0c\u5220\u9664 \u91cd\u542fmysqld, systemctl restart mysqld \u641e\u5b9a\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-535","post","type-post","status-publish","format-standard","hentry","category-java"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=535"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/535\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}