{"id":551,"date":"2017-05-10T16:10:14","date_gmt":"2017-05-10T08:10:14","guid":{"rendered":"http:\/\/blog.defjia.top\/?p=551"},"modified":"2017-05-10T16:10:14","modified_gmt":"2017-05-10T08:10:14","slug":"10th-may-%e5%85%b3%e4%ba%8emysql%e6%81%a2%e5%a4%8droot%e7%94%a8%e6%88%b7%e6%9d%83%e9%99%90%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/blog.defjia.top\/?p=551","title":{"rendered":"10th May \u5173\u4e8eMySQL\u6062\u590droot\u7528\u6237\u6743\u9650\u64cd\u4f5c"},"content":{"rendered":"

\u524d\u8a00\uff1a\u6628\u665a\u672c\u6765\u60f3\u5173\u6389\u67d0\u4e00\u4e2a\u6570\u636e\u5e93\u7684root\u6743\u9650\uff0c\u7ed3\u679c\u6ca1\u60f3\u5230\u53bb\u6389\u4e86root\u7528\u6237\u7684\u5404\u79cd\u6743\u9650\uff0c\u5bfc\u81f4\u670d\u52a1\u5668\u6570\u636e\u5e93\u5d29\u6e83\uff0c\u4e0d\u5f97\u4e0d\u8de8\u6743\u9650\u64cd\u4f5c\uff0c\u52a0\u56de\u6743\u9650\u3002<\/p>\n

\u65b9\u6cd5<\/p>\n

    \n
  1. \u00a0\u5728cmd\u4e2d\u8f93\u5165net stop mysql \u00a0#\u5148\u505c\u6b62MySQL\u670d\u52a1<\/li>\n
  2. \u8fdb\u5165Mysql Bin\u76ee\u5f55\uff0c\u6267\u884c mysqld -nt –skip-grant-tables \u00a0#\u4ee5\u4e0d\u68c0\u67e5\u6743\u9650\u7684\u65b9\u5f0f\u542f\u52a8<\/li>\n
  3. \u6b64\u65f6\u8fd9\u4e2acmd\u8fdb\u5165\u6301\u7eed\u8fd0\u884c\u72b6\u6001(\u8868\u8ff0\u4e0d\u592a\u5bf9)\uff0c\u6240\u4ee5\u8981\u91cd\u65b0\u5f00\u6253\u4e00\u4e2a\u547d\u4ee4\u63d0\u793a\u7b26\u7684\u7a97\u53e3(CMD)\u7528\u7a7a\u5bc6\u7801\u65b9\u5f0f\u4f7f\u7528root\u7528\u6237\u767b\u5f55MySQL\uff1b<\/li>\n
  4. mysql -u root;<\/li>\n
  5. use mysql ;<\/li>\n
  6. UPDATE<\/span>\u00a0USER<\/span>\u00a0SET<\/span>\u00a0select_priv=‘Y’<\/span>,Insert_priv=‘Y’<\/span>,Update_priv=‘Y’<\/span>,Delete_priv=‘Y’<\/span>,Create_priv=‘Y’<\/span>,Drop_priv=‘Y’<\/span>,Reload_priv=‘Y’<\/span>,File_priv=‘Y’<\/span>,Grant_priv=‘Y’<\/span>,References_priv=‘Y’<\/span>,Index_priv=‘Y’<\/span>,Alter_priv=‘Y’<\/span>,Show_db_priv=‘Y’<\/span>,Super_priv=‘Y’<\/span>,Create_tmp_table_priv=‘Y’<\/span>,Lock_tables_priv=‘Y’<\/span>,Execute_priv=‘Y’<\/span>,Repl_slave_priv=‘Y’<\/span>,Repl_client_priv=‘Y’<\/span>,Create_view_priv=‘Y’<\/span>,Show_view_priv=‘Y’<\/span>,Create_routine_priv=‘Y’<\/span>,Alter_routine_priv=‘Y’<\/span>,Create_user_priv=‘Y’<\/span>,Event_priv=‘Y’<\/span>,Trigger_priv=‘Y’<\/span>,Create_tablespace_priv=‘Y’<\/span>\u00a0\u00a0\u00a0WHERE<\/span>\u00a0user<\/span>=‘root’<\/span>; #\u5373\u52a0\u56de\u6240\u6709\u6743\u9650<\/li>\n
  7. update<\/span>\u00a0mysql.user<\/span>\u00a0set<\/span>\u00a0password<\/span>=PASSWORD<\/span>(‘password’<\/span>)\u00a0where<\/span>\u00a0User<\/span>=‘root’<\/span>; \u00a0#\u5fd8\u8bb0\u5bc6\u7801\u65f6\u7684\u64cd\u4f5c<\/li>\n
  8. flush privileges; #\u5237\u65b0\u6743\u9650<\/li>\n
  9. exit; #\u9000\u51faMySQL<\/li>\n
  10. net start mysql #\u91cd\u542f\u670d\u52a1\uff0c\u641e\u5b9a<\/li>\n<\/ol>\n

    \u53d1\u8a93\u5728\u5b66\u5b8c\u8fd9\u5b66\u671f\u7684\u6570\u636e\u5e93\u4e4b\u524d\u4e0d\u4e71\u6298\u817e\u6570\u636e\u5e93\u4e86\u3002<\/p>\n

    reference:\u00a0http:\/\/blog.csdn.net\/cycao313\/article\/details\/8454607<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u524d\u8a00\uff1a\u6628\u665a\u672c\u6765\u60f3\u5173\u6389\u67d0\u4e00\u4e2a\u6570\u636e\u5e93\u7684root\u6743\u9650\uff0c\u7ed3\u679c\u6ca1\u60f3\u5230\u53bb\u6389\u4e86root\u7528\u6237\u7684\u5404\u79cd\u6743\u9650\uff0c\u5bfc\u81f4\u670d\u52a1\u5668\u6570\u636e\u5e93\u5d29\u6e83\uff0c\u4e0d\u5f97\u4e0d\u8de8\u6743\u9650\u64cd\u4f5c\uff0c\u52a0\u56de\u6743\u9650\u3002 \u65b9\u6cd5 \u00a0\u5728cmd\u4e2d\u8f93\u5165net stop mysql \u00a0#\u5148\u505c\u6b62MySQL\u670d\u52a1 \u8fdb\u5165Mysql Bin\u76ee\u5f55\uff0c\u6267\u884c mysqld -nt –skip-grant-tables \u00a0#\u4ee5\u4e0d\u68c0\u67e5\u6743\u9650\u2026\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-551","post","type-post","status-publish","format-standard","hentry","category-3"],"_links":{"self":[{"href":"https:\/\/blog.defjia.top\/index.php?rest_route=\/wp\/v2\/posts\/551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.defjia.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.defjia.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.defjia.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.defjia.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=551"}],"version-history":[{"count":0,"href":"https:\/\/blog.defjia.top\/index.php?rest_route=\/wp\/v2\/posts\/551\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.defjia.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.defjia.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.defjia.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}