[{"id":812,"title":"\u5b89\u88c5MySQL\u7eff\u8272\u7248\u5177\u4f53\u6b65\u9aa4\uff0c\u4eb2\u6d4b\u6709\u6548","content":"
    \r\n
  1. \u4e0b\u8f7d\u5730\u5740\uff1ahttps:\/\/downloads.mysql.com\/archives\/community\/<\/a><\/li>\r\n
  2. \u89e3\u538b\u81f3D\u76d8\u6839\u76ee\u5f55\u00a0D:mysql-xxx-winx64<\/li>\r\n
  3. \u5728D:mysql-xxx-winx64bin\u76ee\u5f55\u4e0b\u521b\u5efamy.ini\u6587\u4ef6\uff0c\u8981\u7528utf8\u65e0\u7b7e\u540d\u7f16\u7801<\/li>\r\n<\/ol>\r\n
    [mysql]\r\nsql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\r\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6\r\ndefault-character-set=utf8\r\n[mysqld]\r\n# \u8bbe\u7f6e3306\u7aef\u53e3\r\nport=3306\r\n# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55\r\nbasedir=D:mysql-xxx-winx64\r\n# \u8bbe\u7f6emysql\u6570\u636e\u5e93\u7684\u6570\u636e\u7684\u5b58\u653e\u76ee\u5f55\r\ndatadir=D:mysql-xxx-winx64data\r\n# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570\r\nmax_connections=200\r\n# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3a8\u6bd4\u7279\u7f16\u7801\u7684latin1\u5b57\u7b26\u96c6\r\ncharacter-set-server=utf8\r\n# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\r\ndefault-storage-engine=INNODB\r\n<\/pre>\r\n
      \r\n
    1. \u5728\u7cfb\u7edf\u73af\u5883\u53d8\u91cfPath\u4e2d\u6dfb\u52a0\uff1aD:mysql-xxxbin;
      \"\"<\/li>\r\n
    2. \u4ee5\u7ba1\u7406\u5458\u6743\u9650\u8fd0\u884cCMD\uff08C:WindowsSystem32cmd.exe\u00a0 \u7528\u7ba1\u7406\u5458\u6743\u9650\u8fd0\u884c\uff09<\/li>\r\n
    3. \u8f93\u5165\u547d\u4ee4\uff1a<\/li>\r\n<\/ol>\r\n
       <\/p>\r\n
      <\/code><\/code><\/p>\r\n
      <\/code><\/code><\/p>\r\n
      <\/code><\/code><\/p>\r\n
      <\/code><\/code><\/p>\r\n
      D:\r\n\r\ncd\u00a0mysql-xxx-winx64bin\r\n\r\nmysqld --defaults-file=my.ini --initialize-insecure\r\n\r\nmysqld --install\r\n\r\n\u5982\u679c\u63d0\u793a<\/span>\r\n\r\nMySQL\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\uff0c\u670d\u52a1\u6ca1\u6709\u62a5\u544a\u4efb\u4f55\u9519\u8bef\uff0c\u8bf7\u952e\u5165 NET HELPMSG 3534 \u4ee5\u83b7\u5f97\u66f4\u591a\u7684\u5e2e\u52a9<\/span>\r\n\r\n\u8fdb\u5165D:mysql-xxx-winx64data\u5220\u9664\u6587\u4ef6\u4e2d\u6240\u6709\u6587\u4ef6\uff0c\u91cd\u65b0\u8f93\u5165\u547d\u4ee4<\/span>\r\n\r\nmysqld --defaults-file=my.ini --initialize-insecure<\/span>\r\n\r\nmysql net start<\/span>\r\n\r\nmysql -u root -p\uff08\u4e0d\u8981\u8f93\u5165\u5bc6\u7801\uff09\r\n\r\nuse mysql;\r\nselect host,user,authentication_string,plugin from user;\r\nalter user 'root'@'localhost' identified with mysql_native_password by '123456';\r\n\r\nQuery OK, 0 rows affected (0.05 sec)<\/strong><\/pre>\r\n
      \u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee\u6743\u9650<\/p>\r\n
      update user set host='%' where user='root'; flush privileges; exit;<\/pre>\r\n
      \u91cd\u542f\u670d\u52a1<\/p>\r\n
      net stop mysql\r\nnet start mysql<\/pre>\r\n
      \u5df2\u88c5\u597d\uff0c\u66f4\u6362\u7535\u8111\u6216\u8005\u91cd\u88c5\u7cfb\u7edf--------------------------------------------<\/strong><\/p>\r\n
        \r\n
      1. \u5728\u7cfb\u7edf\u73af\u5883\u53d8\u91cfPath\u4e2d\u6dfb\u52a0\uff1aD:mysql-8.0.24-winx64bin;<\/li>\r\n
      2. \u4ee5\u7ba1\u7406\u5458\u6743\u9650\u8fd0\u884cCMD<\/li>\r\n
      3. \u8f93\u5165\u547d\u4ee4\uff1a<\/li>\r\n<\/ol>\r\n
        D:\r\n\r\ncd\u00a0mysql-8.0.24-winx64bin\r\n\r\nmysqld --defaults-file=my.ini --initialize-insecure\r\n\r\nmysqld --install<\/pre>\r\n
          \r\n
        1. \u91cd\u542f\u670d\u52a1<\/li>\r\n<\/ol>\r\n
          net stop mysql\r\nnet start mysql<\/pre>","date":"2022-06-19"},{"id":814,"title":"\u5982\u4f55\u5728\u672c\u5730\u642d\u5efa\u4e00\u4e2aWordPress\u7f51\u7ad9","content":"