{"id":1683,"date":"2017-01-20T23:20:15","date_gmt":"2017-01-20T15:20:15","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1683"},"modified":"2017-01-20T23:20:15","modified_gmt":"2017-01-20T15:20:15","slug":"mysql-%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql-%e7%ae%a1%e7%90%86\/","title":{"rendered":"MySQL \u7ba1\u7406"},"content":{"rendered":"

\u542f\u52a8\u53ca\u5173\u95ed MySQL \u670d\u52a1\u5668<\/h2>\n

\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u6765\u68c0\u67e5MySQL\u670d\u52a1\u5668\u662f\u5426\u542f\u52a8\uff1a<\/p>\n

ps <\/span>-<\/span>ef <\/span>|<\/span> grep mysqld<\/span><\/pre>\n
\u5982\u679cMySql\u5df2\u7ecf\u542f\u52a8\uff0c\u4ee5\u4e0a\u547d\u4ee4\u5c06\u8f93\u51famysql\u8fdb\u7a0b\u5217\u8868\uff0c \u5982\u679cmysql\u672a\u542f\u52a8\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u6765\u542f\u52a8mysql\u670d\u52a1\u5668:<\/p>\n
root@host<\/span># cd \/usr\/bin<\/span>\r\n.\/<\/span>mysqld_safe <\/span>&<\/span><\/pre>\n
\u5982\u679c\u4f60\u60f3\u5173\u95ed\u76ee\u524d\u8fd0\u884c\u7684 MySQL \u670d\u52a1\u5668, \u4f60\u53ef\u4ee5\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4:<\/p>\n
root@host<\/span># cd \/usr\/bin<\/span>\r\n.\/<\/span>mysqladmin <\/span>-<\/span>u root <\/span>-<\/span>p shutdown\r\n<\/span>Enter<\/span> password<\/span>:<\/span> ******<\/span><\/pre>\n
\n
MySQL \u7528\u6237\u8bbe\u7f6e<\/h2>\n
\u5982\u679c\u4f60\u9700\u8981\u6dfb\u52a0 MySQL \u7528\u6237\uff0c\u4f60\u53ea\u9700\u8981\u5728 mysql \u6570\u636e\u5e93\u4e2d\u7684 user \u8868\u6dfb\u52a0\u65b0\u7528\u6237\u5373\u53ef\u3002<\/p>\n
\u4ee5\u4e0b\u4e3a\u6dfb\u52a0\u7528\u6237\u7684\u7684\u5b9e\u4f8b\uff0c\u7528\u6237\u540d\u4e3aguest\uff0c\u5bc6\u7801\u4e3aguest123\uff0c\u5e76\u6388\u6743\u7528\u6237\u53ef\u8fdb\u884c SELECT, INSERT \u548c UPDATE\u64cd\u4f5c\u6743\u9650\uff1a<\/p>\n
root@host<\/span># mysql -u root -p<\/span>\r\nEnter<\/span> password<\/span>:*******<\/span>\r\nmysql<\/span>><\/span> use<\/span> mysql<\/span>;<\/span>\r\nDatabase<\/span> changed\r\n\r\nmysql<\/span>><\/span> INSERT INTO user \r\n          <\/span>(<\/span>host<\/span>,<\/span> user<\/span>,<\/span> password<\/span>,<\/span> \r\n           select_priv<\/span>,<\/span> insert_priv<\/span>,<\/span> update_priv<\/span>)<\/span> \r\n           VALUES <\/span>(<\/span>'localhost'<\/span>,<\/span> 'guest'<\/span>,<\/span> \r\n           PASSWORD<\/span>(<\/span>'guest123'<\/span>),<\/span> 'Y'<\/span>,<\/span> 'Y'<\/span>,<\/span> 'Y'<\/span>);<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 1<\/span> row affected <\/span>(<\/span>0.20<\/span> sec<\/span>)<\/span>\r\n\r\nmysql<\/span>><\/span> FLUSH PRIVILEGES<\/span>;<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 1<\/span> row affected <\/span>(<\/span>0.01<\/span> sec<\/span>)<\/span>\r\n\r\nmysql<\/span>><\/span> SELECT host<\/span>,<\/span> user<\/span>,<\/span> password FROM user WHERE user <\/span>=<\/span> 'guest'<\/span>;<\/span>\r\n+-----------+---------+------------------+<\/span>\r\n|<\/span> host      <\/span>|<\/span> user    <\/span>|<\/span> password         <\/span>|<\/span>\r\n+-----------+---------+------------------+<\/span>\r\n|<\/span> localhost <\/span>|<\/span> guest <\/span>|<\/span> 6f8c114b58f2ce9e<\/span> |<\/span>\r\n+-----------+---------+------------------+<\/span>\r\n1<\/span> row <\/span>in<\/span> set<\/span> (<\/span>0.00<\/span> sec<\/span>)<\/span><\/pre>\n
\u5728\u6dfb\u52a0\u7528\u6237\u65f6\uff0c\u8bf7\u6ce8\u610f\u4f7f\u7528MySQL\u63d0\u4f9b\u7684 PASSWORD() \u51fd\u6570\u6765\u5bf9\u5bc6\u7801\u8fdb\u884c\u52a0\u5bc6\u3002 \u4f60\u53ef\u4ee5\u5728\u4ee5\u4e0a\u5b9e\u4f8b\u770b\u5230\u7528\u6237\u5bc6\u7801\u52a0\u5bc6\u540e\u4e3a\uff1a 6f8c114b58f2ce9e.<\/p>\n
 \u6ce8\u610f\uff1a<\/strong>\u5728 MySQL5.7 \u4e2d user \u8868\u7684 password \u5df2\u6362\u6210\u4e86authentication_string<\/strong>\u3002<\/p>\n
 \u6ce8\u610f\uff1a<\/strong>\u5728\u6ce8\u610f\u9700\u8981\u6267\u884c FLUSH PRIVILEGES<\/strong> \u8bed\u53e5\u3002 \u8fd9\u4e2a\u547d\u4ee4\u6267\u884c\u540e\u4f1a\u91cd\u65b0\u8f7d\u5165\u6388\u6743\u8868\u3002<\/p>\n
\u5982\u679c\u4f60\u4e0d\u4f7f\u7528\u8be5\u547d\u4ee4\uff0c\u4f60\u5c31\u65e0\u6cd5\u4f7f\u7528\u65b0\u521b\u5efa\u7684\u7528\u6237\u6765\u8fde\u63a5mysql\u670d\u52a1\u5668\uff0c\u9664\u975e\u4f60\u91cd\u542fmysql\u670d\u52a1\u5668\u3002<\/p>\n
\u4f60\u53ef\u4ee5\u5728\u521b\u5efa\u7528\u6237\u65f6\uff0c\u4e3a\u7528\u6237\u6307\u5b9a\u6743\u9650\uff0c\u5728\u5bf9\u5e94\u7684\u6743\u9650\u5217\u4e2d\uff0c\u5728\u63d2\u5165\u8bed\u53e5\u4e2d\u8bbe\u7f6e\u4e3a ‘Y’ \u5373\u53ef\uff0c\u7528\u6237\u6743\u9650\u5217\u8868\u5982\u4e0b\uff1a<\/p>\n
    \n
  • Select_priv<\/li>\n
  • Insert_priv<\/li>\n
  • Update_priv<\/li>\n
  • Delete_priv<\/li>\n
  • Create_priv<\/li>\n
  • Drop_priv<\/li>\n
  • Reload_priv<\/li>\n
  • Shutdown_priv<\/li>\n
  • Process_priv<\/li>\n
  • File_priv<\/li>\n
  • Grant_priv<\/li>\n
  • References_priv<\/li>\n
  • Index_priv<\/li>\n
  • Alter_priv<\/li>\n<\/ul>\n
    \u53e6\u5916\u4e00\u79cd\u6dfb\u52a0\u7528\u6237\u7684\u65b9\u6cd5\u4e3a\u901a\u8fc7SQL\u7684 GRANT \u547d\u4ee4\uff0c\u4f60\u4e0b\u547d\u4ee4\u4f1a\u7ed9\u6307\u5b9a\u6570\u636e\u5e93TUTORIALS\u6dfb\u52a0\u7528\u6237 zara \uff0c\u5bc6\u7801\u4e3a zara123 \u3002<\/p>\n
    root@host<\/span># mysql -u root -p password;<\/span>\r\nEnter<\/span> password<\/span>:*******<\/span>\r\nmysql<\/span>><\/span> use<\/span> mysql<\/span>;<\/span>\r\nDatabase<\/span> changed\r\n\r\nmysql<\/span>><\/span> GRANT SELECT<\/span>,<\/span>INSERT<\/span>,<\/span>UPDATE<\/span>,<\/span>DELETE<\/span>,<\/span>CREATE<\/span>,<\/span>DROP\r\n    <\/span>-><\/span> ON TUTORIALS<\/span>.*<\/span>\r\n    -><\/span> TO <\/span>'zara'<\/span>@<\/span>'localhost'<\/span>\r\n    -><\/span> IDENTIFIED BY <\/span>'zara123'<\/span>;<\/span><\/pre>\n
    \u4ee5\u4e0a\u547d\u4ee4\u4f1a\u5728mysql\u6570\u636e\u5e93\u4e2d\u7684user\u8868\u521b\u5efa\u4e00\u6761\u7528\u6237\u4fe1\u606f\u8bb0\u5f55\u3002<\/p>\n
    \u6ce8\u610f:<\/strong> MySQL \u7684SQL\u8bed\u53e5\u4ee5\u5206\u53f7 (;) \u4f5c\u4e3a\u7ed3\u675f\u6807\u8bc6\u3002<\/p>\n
    \n
    \/etc\/my.cnf \u6587\u4ef6\u914d\u7f6e<\/h2>\n
    \u4e00\u822c\u60c5\u51b5\u4e0b\uff0c\u4f60\u4e0d\u9700\u8981\u4fee\u6539\u8be5\u914d\u7f6e\u6587\u4ef6\uff0c\u8be5\u6587\u4ef6\u9ed8\u8ba4\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n
    [<\/span>mysqld<\/span>]<\/span>\r\ndatadir<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql\r\nsocket<\/span>=<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql<\/span>\/<\/span>mysql<\/span>.<\/span>sock\r\n\r\n<\/span>[<\/span>mysql<\/span>.<\/span>server<\/span>]<\/span>\r\nuser<\/span>=<\/span>mysql\r\nbasedir<\/span>=<\/span>\/var\/<\/span>lib\r\n\r\n<\/span>[<\/span>safe_mysqld<\/span>]<\/span>\r\nerr<\/span>-<\/span>log<\/span>=<\/span>\/var\/<\/span>log<\/span>\/<\/span>mysqld<\/span>.<\/span>log\r\npid<\/span>-<\/span>file<\/span>=<\/span>\/var\/<\/span>run<\/span>\/<\/span>mysqld<\/span>\/<\/span>mysqld<\/span>.<\/span>pid<\/span><\/pre>\n
    \u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c\u4f60\u53ef\u4ee5\u6307\u5b9a\u4e0d\u540c\u7684\u9519\u8bef\u65e5\u5fd7\u6587\u4ef6\u5b58\u653e\u7684\u76ee\u5f55\uff0c\u4e00\u822c\u4f60\u4e0d\u9700\u8981\u6539\u52a8\u8fd9\u4e9b\u914d\u7f6e\u3002<\/p>\n
    \n
    \u7ba1\u7406MySQL\u7684\u547d\u4ee4<\/h2>\n
    \u4ee5\u4e0b\u5217\u51fa\u4e86\u4f7f\u7528Mysql\u6570\u636e\u5e93\u8fc7\u7a0b\u4e2d\u5e38\u7528\u7684\u547d\u4ee4\uff1a<\/p>\n