\u3000\u4e00\u3001MySQL\u4fee\u6539\u5bc6\u7801\u65b9\u6cd5\u603b\u7ed3 <\/p>\n
\u3000\u3000\u9996\u5148\u8981\u8bf4\u660e\u4e00\u70b9\u7684\u662f\uff1a\u4e00\u822c\u60c5\u51b5\u4e0b\uff0c\u4fee\u6539MySQL\u5bc6\u7801\u662f\u9700\u8981\u6709mysql\u91cc\u7684root\u6743\u9650\u7684\uff0c\u8fd9\u6837\u4e00\u822c\u7528\u6237\u662f\u65e0\u6cd5\u66f4\u6539\u5bc6\u7801\u7684\uff0c\u9664\u975e\u8bf7\u6c42\u7ba1\u7406\u5458\u5e2e\u52a9\u4fee\u6539\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e00 \u3000\u3000 <\/p>\n
\u3000\u3000\u4f7f\u7528phpMyAdmin <\/p>\n
\u3000\u3000(\u56fe\u5f62\u5316\u7ba1\u7406MySql\u6570\u636e\u5e93\u7684\u5de5\u5177)\uff0c\u8fd9\u662f\u6700\u7b80\u5355\u7684\uff0c\u76f4\u63a5\u7528SQL\u8bed\u53e5\u4fee\u6539mysql\u6570\u636e\u5e93\u5e93\u7684user\u8868\uff0c\u4e0d\u8fc7\u522b\u5fd8\u4e86\u4f7f\u7528PASSWORD\u51fd\u6570\uff0c\u63d2\u5165\u7528\u6237\u7528Insert\u547d\u4ee4\uff0c\u4fee\u6539\u7528\u6237\u7528Update\u547d\u4ee4\uff0c\u5220\u9664\u7528Delete\u547d\u4ee4\u3002\u5728\u672c\u8282\u540e\u9762\u6709\u6570\u636e\u8868user\u5b57\u6bb5\u7684\u8be6\u7ec6\u4ecb\u7ecd\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e8c \u3000\u3000 <\/p>\n
\u3000\u3000\u4f7f\u7528mysqladmin\u3002\u8f93\u5165 \u3000 <\/p>\n
\u3000\u3000mysqladmin -u root -p oldpassword newpasswd \u3000\u3000 <\/p>\n
\u3000\u3000\u6267\u884c\u8fd9\u4e2a\u547d\u4ee4\u540e\uff0c\u9700\u8981\u8f93\u5165root\u7684\u539f\u5bc6\u7801\uff0c\u8fd9\u6837root\u7684\u5bc6\u7801\u5c06\u6539\u4e3anewpasswd\u3002\u540c\u6837\uff0c\u628a\u547d\u4ee4\u91cc\u7684root\u6539\u4e3a\u4f60\u7684\u7528\u6237\u540d\uff0c\u4f60\u5c31\u53ef\u4ee5\u6539\u4f60\u81ea\u5df1\u7684\u5bc6\u7801\u4e86\u3002 <\/p>\n
\u3000\u3000\u5f53\u7136\u5982\u679c\u4f60\u7684mysqladmin\u8fde\u63a5\u4e0d\u4e0amysql <\/p>\n
\u3000\u3000server\uff0c\u6216\u8005\u4f60\u6ca1\u6709\u529e\u6cd5\u6267\u884cmysqladmin\uff0c\u90a3\u4e48\u8fd9\u79cd\u65b9\u6cd5\u5c31\u662f\u65e0\u6548\u7684\uff0c\u800c\u4e14mysqladmin\u65e0\u6cd5\u628a\u5bc6\u7801\u6e05\u7a7a\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u4e0b\u9762\u7684\u65b9\u6cd5\u90fd\u5728mysql\u63d0\u793a\u7b26\u4e0b\u4f7f\u7528\uff0c\u4e14\u5fc5\u987b\u6709mysql\u7684root\u6743\u9650\uff1a \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e09 \u3000\u3000 <\/p>\n
\u3000\u3000mysql> Insert INTO mysql.user (Host,User,Password) VALUES <\/p>\n
\u3000\u3000(‘%’,’system’, PASSWORD(‘manager’)); <\/p>\n
\u3000\u3000mysql> FLUSH PRIVILEGES \u3000\u3000 <\/p>\n
\u3000\u3000\u786e\u5207\u5730\u8bf4\u8fd9\u662f\u5728\u589e\u52a0\u4e00\u4e2a\u7528\u6237\uff0c\u7528\u6237\u540d\u4e3asystem\uff0c\u5bc6\u7801\u4e3amanager\u3002\u6ce8\u610f\u8981\u4f7f\u7528PASSWORD\u51fd\u6570\uff0c\u7136\u540e\u8fd8\u8981\u4f7f\u7528FLUSH <\/p>\n
\u3000\u3000PRIVILEGES\u6765\u6267\u884c\u786e\u8ba4\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u56db \u3000\u3000 <\/p>\n
\u3000\u3000\u548c\u65b9\u6cd5\u4e09\u4e00\u6837\uff0c\u53ea\u662f\u4f7f\u7528\u4e86REPLACE\u8bed\u53e5 <\/p>\n
\u3000\u3000mysql> REPLACE INTO mysql.user (Host,User,Password) <\/p>\n
\u3000\u3000VALUES(‘%’,’system’,PASSWORD(‘manager’)); <\/p>\n
\u3000\u3000mysql> FLUSH PRIVILEGES \u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e94 \u3000\u3000 <\/p>\n
\u3000\u3000\u4f7f\u7528SET PASSWORD\u8bed\u53e5 \u3000\u3000 <\/p>\n
\u3000\u3000mysql> SET PASSWORD FOR system@”%” = PASSWORD(‘manager’); \u3000\u3000 <\/p>\n
\u3000\u3000\u4f60\u4e5f\u5fc5\u987b\u4f7f\u7528PASSWORD()\u51fd\u6570\uff0c\u4f46\u662f\u4e0d\u9700\u8981\u4f7f\u7528FLUSH PRIVILEGES\u6765\u6267\u884c\u786e\u8ba4\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u516d \u3000\u3000 <\/p>\n
\u3000\u3000\u4f7f\u7528GRANT … IDENTIFIED BY\u8bed\u53e5\uff0c\u6765\u8fdb\u884c\u6388\u6743\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000mysql> GRANT USAGE ON *.* TO system@”%” IDENTIFIED BY ‘manager’; \u3000\u3000 <\/p>\n
\u3000\u3000\u8fd9\u91ccPASSWORD()\u51fd\u6570\u662f\u4e0d\u5fc5\u8981\u7684\uff0c\u4e5f\u4e0d\u9700\u8981\u4f7f\u7528FLUSH PRIVILEGES\u6765\u6267\u884c\u786e\u8ba4\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u6ce8\uff1aPASSWORD()\u51fd\u6570\u4f5c\u7528\u662f\u4e3a\u53e3\u4ee4\u5b57\u52a0\u5bc6\uff0c\u5728\u7a0b\u5e8f\u4e2dMySql\u81ea\u52a8\u89e3\u91ca\u3002 \u3000 <\/p>\n
\u3000\u3000\u4e8c\u3001MySql\u4e2d\u8bbf\u95ee\u9650\u5236\u7684\u8bbe\u7f6e\u65b9\u6cd5 <\/p>\n
\u3000\u3000\u6211\u4eec\u91c7\u7528\u4e24\u79cd\u65b9\u6cd5\u6765\u8bbe\u7f6e\u7528\u6237\u3002 <\/p>\n
\u3000\u3000\u8fdb\u5165\u5230Mysql\u6267\u884c\u76ee\u5f55\u4e0b\uff08\u901a\u5e38\u662fc:mysqlbin\uff09\u3002\u8f93\u5165mysqld-shareware.exe\uff0c\u8f93\u5165mysql <\/p>\n
\u3000\u3000–user=root mysql ,\u4e0d\u7136\u4e0d\u80fd\u6dfb\u52a0\u65b0\u7528\u6237\u3002\u8fdb\u5165\u5230mysql>\u63d0\u793a\u7b26\u4e0b\u8fdb\u884c\u64cd\u4f5c\u3002 \u3000\u3000 <\/p>\n
\u3000\u3000\u5047\u8bbe\u6211\u4eec\u8981\u5efa\u7acb\u4e00\u4e2a\u8d85\u7ea7\u7528\u6237\uff0c\u7528\u6237\u540d\u4e3asystem\uff0c\u7528\u6237\u53e3\u4ee4\u4e3amanager\u3002 \u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e00 \u3000 <\/p>\n
\u3000\u3000\u7528Grant \u547d\u4ee4\u6388\u6743\uff0c\u8f93\u5165\u7684\u4ee3\u7801\u5982\u4e0b\uff1a <\/p>\n
\u3000\u3000mysql>GRANT ALL PRIVILEGES ON *.* TO system@localhost IDENTIFIED BY <\/p>\n
\u3000\u3000’manager’ WITH GRANT OPTION; \u3000\u3000 <\/p>\n
\u3000\u3000\u5e94\u663e\u793a:Query OK, 0 rows affected (0.38 sec) \u3000\u3000 <\/p>\n
\u3000\u3000\u65b9\u6cd5\u4e8c \u3000\u3000 <\/p>\n
\u3000\u3000\u5bf9\u7528\u6237\u7684\u6bcf\u4e00\u9879\u6743\u9650\u8fdb\u884c\u8bbe\u7f6e\uff1a \u3000\u3000 <\/p>\n
\u3000\u3000mysql>Insert INTO user <\/p>\n
\u3000\u3000VALUES(‘localhost’,’system’,PASSWORD(‘manager’), <\/p>\n
\u3000\u3000’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’); <\/p>\n
\u3000\u3000\u5bf9\u4e8e3.22.34\u7248\u672c\u7684MySQL,\u8fd9\u91cc\u517114\u4e2a”Y”,\u5176\u76f8\u5e94\u7684\u6743\u9650\u5982\u4e0b(\u6309\u5b57\u6bb5\u987a\u5e8f\u6392\u5217): \u3000\u3000 <\/p>\n
\u3000\u3000\u6743\u9650 \u8868\u5217\u540d\u79f0 \u76f8\u5e94\u89e3\u91ca \u4f7f\u7528\u8303\u56f4 <\/p>\n
\u3000\u3000select Select_priv \u53ea\u6709\u5728\u771f\u6b63\u4ece\u4e00\u4e2a\u8868\u4e2d\u68c0\u7d22\u65f6\u624d\u9700\u8981select\u6743\u9650 \u8868 <\/p>\n
\u3000\u3000insert Insert_priv \u5141\u8bb8\u60a8\u628a\u65b0\u884c\u63d2\u5165\u5230\u4e00\u4e2a\u5b58\u5728\u7684\u8868\u4e2d \u8868 <\/p>\n
\u3000\u3000update Update_priv \u5141\u8bb8\u4f60\u7528\u65b0\u503c\u66f4\u65b0\u73b0\u5b58\u8868\u4e2d\u884c\u7684\u5217 \u8868 <\/p>\n
\u3000\u3000delete Delete_priv \u5141\u8bb8\u4f60\u5220\u9664\u6ee1\u8db3\u6761\u4ef6\u7684\u884c \u8868 <\/p>\n
\u3000\u3000create Create_priv \u5141\u8bb8\u4f60\u521b\u5efa\u65b0\u7684\u6570\u636e\u5e93\u548c\u8868 \u6570\u636e\u5e93\u3001\u8868\u6216\u7d22\u5f15 <\/p>\n
\u3000\u3000drop Drop_priv \u629b\u5f03(\u5220\u9664)\u73b0\u5b58\u7684\u6570\u636e\u5e93\u548c\u8868 \u6570\u636e\u5e93\u6216\u8868 <\/p>\n
\u3000\u3000reload Reload_priv \u5141\u8bb8\u60a8\u544a\u8bc9\u670d\u52a1\u5668\u518d\u8bfb\u5165\u6388\u6743\u8868 \u670d\u52a1\u5668\u7ba1\u7406 <\/p>\n
\u3000\u3000shutdown Shutdown_priv \u53ef\u80fd\u88ab\u6ee5\u7528(\u901a\u8fc7\u7ec8\u6b62\u670d\u52a1\u5668\u62d2\u7edd\u4e3a\u5176\u4ed6\u7528\u6237\u670d\u52a1) \u670d\u52a1\u5668\u7ba1\u7406 <\/p>\n
\u3000\u3000process Process_priv \u5141\u8bb8\u60a8\u5bdf\u770b\u5f53\u524d\u6267\u884c\u7684\u67e5\u8be2\u7684\u666e\u901a\u6587\u672c,\u5305\u62ec\u8bbe\u5b9a\u6216\u6539\u53d8\u53e3\u4ee4\u67e5\u8be2 \u670d\u52a1\u5668\u7ba1\u7406 <\/p>\n
\u3000\u3000file File_priv \u6743\u9650\u53ef\u4ee5\u88ab\u6ee5\u7528\u5728\u670d\u52a1\u5668\u4e0a\u8bfb\u53d6\u4efb\u4f55\u53ef\u8bfb\u7684\u6587\u4ef6\u5230\u6570\u636e\u5e93\u8868 \u670d\u52a1\u5668\u4e0a\u7684\u6587\u4ef6\u5b58\u53d6 <\/p>\n
\u3000\u3000grant Grant_priv \u5141\u8bb8\u4f60\u628a\u4f60\u81ea\u5df1\u62e5\u6709\u7684\u90a3\u4e9b\u6743\u9650\u6388\u7ed9\u5176\u4ed6\u7684\u7528\u6237 \u6570\u636e\u5e93\u6216\u8868 <\/p>\n
\u3000\u3000references References_priv \u5141\u8bb8\u4f60\u6253\u5f00\u548c\u5173\u95ed\u8bb0\u5f55\u6587\u4ef6 \u6570\u636e\u5e93\u6216\u8868 <\/p>\n
\u3000\u3000index Index_priv \u5141\u8bb8\u4f60\u521b\u5efa\u6216\u629b\u5f03(\u5220\u9664)\u7d22\u5f15 \u8868 <\/p>\n
\u3000\u3000alter Alter_priv \u5141\u8bb8\u60a8\u6539\u53d8\u8868\u683c,\u53ef\u4ee5\u7528\u4e8e\u901a\u8fc7\u91cd\u65b0\u547d\u540d\u8868\u6765\u63a8\u7ffb\u6743\u9650\u7cfb\u7edf \u8868 \u3000 <\/p>\n
\u3000\u3000\u5982\u679c\u521b\u5efa\u7528\u6237\u65f6\u53ea\u6709select\u3001insert\u3001update\u548cdelete\u6743\u9650,\u5219\u5141\u8bb8\u7528\u6237\u53ea\u80fd\u5728\u4e00\u4e2a\u6570\u636e\u5e93\u73b0\u6709\u7684\u8868\u4e0a\u5b9e\u65bd\u64cd\u4f5c. <\/p>\n
\u3000\u3000\u4e0b\u9762\u5c31\u53ef\u4ee5\u521b\u5efa\u6211\u4eec\u8981\u7528\u5230\u7684\u6570\u636e\u5e93\u4e86,\u6211\u4eec\u76f4\u63a5\u8f93\u5165. \u4f8b\u5982\uff1a\u6211\u4eec\u8981\u521b\u5efa\u6570\u636e\u5e93\u540d\u4e3aXinXiKu\uff0c\u53ef\u7528\u5982\u4e0b\u4ee3\u7801\uff1a \u3000 <\/p>\n
\u3000\u3000mysql>create database XinXiKu; \u3000\u3000 <\/p>\n
\u3000\u3000\u5e94\u663e\u793a:Query OK, 1 row affected (0.00 sec)<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000\u4e00\u3001MySQL\u4fee\u6539\u5bc6\u7801\u65b9\u6cd5\u603b\u7ed3 \u3000\u3000\u9996\u5148\u8981\u8bf4\u660e\u4e00\u70b9\u7684\u662f\uff1a\u4e00\u822c\u60c5\u51b5\u4e0b\uff0c\u4fee\u6539MySQL\u5bc6\u7801\u662f\u9700\u8981\u6709mysql\u91cc\u7684<\/p>\n