1.\u8d26\u53f7\u914d\u7f6e<\/p>\n
\u00b7 \u5220\u9664\u4e0d\u9700\u8981\u7684\u6570\u636e\u5e93\u8d26\u53f7\u3002<\/p>\n
DROP USER user<\/p>\n
\u5e94\u6309\u7167\u7528\u6237\u5206\u914d\u5e10\u53f7，\u907f\u514d\u4e0d\u540c\u7528\u6237\u95f4\u5171\u4eab\u5e10\u53f7\u3002<\/p>\n
2.\u53e3\u4ee4\u5b89\u5168<\/p>\n
\u00b7 \u4e0d\u4f7f\u7528\u9ed8\u8ba4\u5bc6\u7801\u548c\u7ffc\u5bc6\u7801\u3002<\/p>\n
#\u4fee\u6539\u5bc6\u7801\u547d\u4ee4<\/p>\n
mysql> UPDATE user set password=PASSWORD('testlp3') WHERE user='root\u2019;<\/p>\n
3.\u6743\u9650\u914d\u7f6e<\/p>\n
\u7981\u6b62MySQL\u4ee5\u7cfb\u7edf\u7ba1\u7406\u5458\u8d26\u53f7\u6743\u9650\u8fd0\u884c，\u4f7f\u7528\u975e\u7ba1\u7406\u5458\u4e13\u7528\u8d26\u53f7\u6765\u8fd0\u884cmysql\u670d\u52a1\u3002<\/p>\n
Windows.\u7cfb\u7edf<\/p>\n
\u76f4\u63a5\u6253\u5f00\u4efb\u52a1\u7ba1\u7406\u5668，\u67e5\u770b\u8fd0\u884cmysql\u8fdb\u7a0b\u7684\u64cd\u4f5c\u7cfb\u7edf\u8d26\u53f7，\u4e0d\u80fd\u4e3aadministrator\u8d26\u53f7<\/p>\n
Linux\u7cfb\u7edf<\/p>\n
#\u67e5\u770bmysq1\u670d\u52a1\u7684\u8fd0\u884c\u8d26\u53f7\u662f\u5426\u4e3aroot\u6216\u5176\u4ed6\u9ad8\u6743\u9650\u8d26\u53f7<\/p>\n
ps -ef | grep mysql<\/p>\n
\u6570\u636e\u5e93\u8d26\u6237\u6743\u9650\u914d\u7f6e<\/p>\n
MySQL\u6570\u636e\u5e93\u4e0b\u7684user\u8868\u548cdb\u8868\u4e2d\u5b58\u653e\u7740\u53ef\u4ee5\u6388\u4e88\u6570\u636e\u5e93\u7528\u6237\u7684\u6743\u9650，\u786e\u4fdd\u53ea\u6709\u7ba1\u7406\u5458\u8d26\u53f7\u624d\u80fd\u8bbf\u95ee\u6240\u6709\u6570\u636e\u5e93\u3002\u53ef\u4ee5\u8bbf\u95eemysql\u6570\u636e\u5e93\u7684\u7528\u6237\u6216\u8bb8\u53ef\u4ee5\u67e5\u770b\u5bc6\u7801\u54c8\u5e0c\u503c\u3001\u4fee\u6539\u7528\u6237\u6743\u9650\u7b49\u7b49\u3002<\/p>\n
#\u67e5\u770b\u6570\u636e\u5e93\u6388\u6743\u60c5\u51b5\u3002<\/p>\n
mysql> use mysql;<\/p>\n
mysql> select * from user;<\/p>\n
mysql> select * from db;<\/p>\n
#\u6388\u5b50\u6307\u5b9a\u7528\u6237\u6743\u773c\u6307\u5b9a\u8868\u7684\u6743\u9650<\/p>\n
mysql> Grant select,insert,pdate,delete on tablename to \u2018username'@'hostname';<\/p>\n
4.\u65e5\u5fd7\u914d\u7f6e<\/p>\n
\u6839\u636e\u9700\u6c42\u5f00\u542f\u5bf9\u5e94\u65e5\u5fd7\u7684\u5ba1\u8ba1\u529f\u80fd\u3002<\/p>\n
#\u5f00\u542f\u9519\u8bef\u65e5\u5fd7\u5ba1\u8ba1，\u6253\u5f00my.ini(Windows)\u6216my.cnf(Linux)，\u5728[mysqld]\u4e0b\u6dfb\u52a0<\/p>\n
log-error="\/var\/log\/mysqld.log"<\/p>\n
5.\u8bbf\u95ee\u63a7\u5236<\/p>\n
\u4fee\u6539MySQL\u9ed8\u8ba4\u7aef\u53e33306\u3002<\/p>\n
#\u6253\u5f00my.ini\u6216\u8005my.cnf,\u5728[mysqld]\u4e0b\u4fee\u6539<\/p>\n
#\u4fee\u6539\u6210\u5408\u9002\u7aef\u53e3<\/p>\n
port=3306<\/p>\n
\u7f51\u7edc\u8bbf\u95ee\u9650\u5236，\u5728\u9632\u706b\u5899\u4e2d\u505a\u9650\u5236，\u53ea\u5141\u8bb8\u4e0e\u6307\u5b9a\u7684IP\u5730\u5740\u4e0e3306\u7aef\u53e3(\u6216MySQL\u6570\u636e\u5e93\u7684\u6307\u5b9a\u7aef\u53e3)\u901a\u8baf\u3002<\/p>\n
#\u521b\u5efa\u6307\u5b9aIP\u7684\u8fdc\u7a0b\u7528\u6237<\/p>\n
mysql> GRANT ALl privileges on \u5e93\u540d.\u8868\u540d to \u2018\u7528\u6237\u540d'@'IP\u5730\u5740\u2019 identified by \u2018\u5bc6\u7801\u2019 with grant option;<\/p>\n
mysql> flush privileges;<\/p>\n
6.\u5176\u4ed6\u914d\u7f6e.<\/p>\n
\u00b7\u5b89\u88c5\u6700\u65b0\u7684\u5b89\u5168\u8865\u4e01\u65e5\u5fd7，\u901a\u8fc7SELECT VERSIONO\u67e5\u770b\u7248\u672c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
1.\u8d26\u53f7\u914d\u7f6e\u00b7 \u5220\u9664\u4e0d\u9700\u8981\u7684\u6570\u636e\u5e93\u8d26\u53f7\u3002DROP USER user\u5e94\u6309\u7167\u7528\u6237\u5206\u914d\u5e10\u53f7，\u907f\u514d\u4e0d\u540c\u7528\u6237\u95f4\u5171\u4eab\u5e10\u53f7\u30022.\u53e3\u4ee4\u5b89\u5168\u00b7 \u4e0d\u4f7f\u7528\u9ed8\u8ba4\u5bc6\u7801\u548c\u7ffc\u5bc6\u7801\u3002#\u4fee\u6539\u5bc6\u7801\u547d\u4ee4mysql> UPDATE user set passwordPASSWORD(testlp3) WHERE userroot\u2019;3.\u6743\u9650\u914d\u7f6e\u7981\u6b62MySQL\u4ee5\u7cfb\u7edf\u7ba1\u7406\u5458\u8d26\u53f7\u6743\u9650\u8fd0\u884c，\u4f7f\u7528\u975e\u7ba1\u7406\u5458\u4e13\u7528\u8d26\u53f7\u6765\u8fd0\u884cmysql\u670d\u52a1\u3002Windows.\u7cfb\u7edf\u76f4\u63a5\u6253\u5f00\u4efb\u52a1\u7ba1\u7406\u5668，\u67e5\u770b\u8fd0\u884c<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[116],"topic":[],"class_list":["post-90686","post","type-post","status-publish","format-standard","hentry","category-server","tag-adb"],"yoast_head":"\n