{"id":295,"date":"2018-10-02T20:46:29","date_gmt":"2018-10-02T12:46:29","guid":{"rendered":"https:\/\/chenbing.name\/?p=295"},"modified":"2020-05-22T15:09:15","modified_gmt":"2020-05-22T07:09:15","slug":"windows10%e5%ae%89%e8%a3%85mysql5-7-23%e8%a7%a3%e5%8e%8b%e7%89%88%e5%8f%8aphpstudy%e4%b8%8b%e5%8d%87%e7%ba%a7mysql%e5%88%b05-7%e5%a1%ab%e5%9d%91%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/chenbing.name\/blog\/295\/","title":{"rendered":"windows10\u5b89\u88c5mysql5.7.23\u89e3\u538b\u7248\u53caphpstudy\u4e0b\u5347\u7ea7mysql\u52305.7\u586b\u5751\u8bb0\u5f55"},"content":{"rendered":"<h2 id=\"windows10\u4e0b\u5b89\u88c5\u89e3\u538b\u7248mysql5.7.23\"><span class=\"ez-toc-section\" id=\"windows10%E4%B8%8B%E5%AE%89%E8%A3%85%E8%A7%A3%E5%8E%8B%E7%89%88mysql_5723\"><\/span>windows10\u4e0b\u5b89\u88c5\u89e3\u538b\u7248mysql 5.7.23<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 id=\"1\u3001\u89e3\u538b\u548c\u521d\u59cb\u5316\uff1a\"><span class=\"ez-toc-section\" id=\"1%E3%80%81%E8%A7%A3%E5%8E%8B%E5%92%8C%E5%88%9D%E5%A7%8B%E5%8C%96%EF%BC%9A\"><\/span>1\u3001\u89e3\u538b\u548c\u521d\u59cb\u5316\uff1a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<p>\u5b98\u7f51\u4e0b\u8f7d\uff1a<a href=\"https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.23-winx64.zip\">https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.23-winx64.zip<\/a><\/p>\n<\/li>\n<li>\n<p>\u89e3\u538b\u5230\u81ea\u5df1\u6253\u7b97\u5b89\u88c5\u7684\u76ee\u5f55\uff0c\u6211\u4eec\u662f\u6253\u7b97\u5347\u7ea7phpstudy2018\u7684\uff0c\u6240\u4ee5\u653e\u5728\u5982\u4e0b\u76ee\u5f55\uff1aD:\\phpStudy\\PHPTutorial\\MySQL <br \/>\n\uff08\u8bb0\u5f97\u5907\u4efd\u539f\u6765\u7684mysql5.5\uff09<\/p>\n<\/li>\n<li>\u5728mysql\u6839\u76ee\u5f55\u521b\u5efa my.ini\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/li>\n<\/ul>\n<blockquote>\n<p>[client] <br \/>\n  port=3306 <br \/>\n  [mysql] <br \/>\n  default-character-set=utf8 <br \/>\n  [mysqld] <br \/>\n  port=3306 <br \/>\n  basedir=&#8221;D:\/phpStudy\/PHPTutorial\/MySQL\/&#8221; <br \/>\n  datadir=&#8221;D:\/phpStudy\/PHPTutorial\/MySQL\/data\/&#8221; <br \/>\n  character-set-server=utf8 <br \/>\n  default-storage-engine=INNODB<\/p>\n<\/blockquote>\n<p>\u8bb0\u5f97\u628a\u4e0a\u9762basedir\u3001datadir\u6539\u6210\u4f60\u7684mysql\u76ee\u5f55<\/p>\n<ul>\n<li>\u4f7f\u7528\u7ba1\u7406\u5458\u8eab\u4efd\u8fd0\u884ccmd\u3002<\/li>\n<li>\u8df3\u8f6c\u5230D:\/phpStudy\/PHPTutorial\/MySQL\/bin\u76ee\u5f55<\/li>\n<li>\u8fd0\u884c<code>mysqld --initialize-insecure<\/code>\uff0c\u81ea\u52a8\u751f\u6210\u65e0\u5bc6\u7801\u7684root\u7528\u6237\u5e76\u521d\u59cb\u5316mysql\u3002<\/li>\n<\/ul>\n<h3 id=\"2\u3001\u5b89\u88c5mysql\u670d\u52a1\uff0c\u5e76\u542f\u52a8\u670d\u52a1\u3002\"><span class=\"ez-toc-section\" id=\"2%E3%80%81%E5%AE%89%E8%A3%85mysql%E6%9C%8D%E5%8A%A1%EF%BC%8C%E5%B9%B6%E5%90%AF%E5%8A%A8%E6%9C%8D%E5%8A%A1%E3%80%82\"><\/span>2\u3001\u5b89\u88c5mysql\u670d\u52a1\uff0c\u5e76\u542f\u52a8\u670d\u52a1\u3002<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u5982\u679c\u53ea\u662f\u5347\u7ea7phpstudy\u7684mysql\uff0c\u8fd9\u4e00\u6b65\u5c31\u4e0d\u9700\u8981\u4e86\uff0cphpstudy\u9ed8\u8ba4\u5df2\u7ecf\u5b89\u88c5\u4e86mysql\u670d\u52a1\uff0c\u53ef\u4ee5\u5728windows\u7cfb\u7edf\u670d\u52a1\u4e2d\u627e\u5230\uff0c\u540d\u5b57\u53eb<code>MySQLa<\/code>\u3002 <br \/>\n\u76f4\u63a5\u4f7f\u7528phpstudy\u9762\u677f\u542f\u52a8\u5373\u53ef\u3002<\/p>\n<p>\u5982\u679c\u4f60\u662f\u5355\u72ec\u5b89\u88c5mysql 5.7.23\uff0c\u5728D:\/phpStudy\/PHPTutorial\/MySQL\/bin\u76ee\u5f55\u4e0b\u8fd0\u884c <br \/>\n<code>mysqld -install<\/code> <br \/>\n\u5b89\u88c5mysql\u670d\u52a1\uff0c\u4e0d\u51fa\u610f\u5916\uff0c\u5219\u63d0\u793a<code>Service successfully installed<\/code>\u5b89\u88c5\u6210\u529f\u3002<\/p>\n<h3 id=\"3\u3001\u8bbe\u7f6eroot\u5bc6\u7801\"><span class=\"ez-toc-section\" id=\"3%E3%80%81%E8%AE%BE%E7%BD%AEroot%E5%AF%86%E7%A0%81\"><\/span>3\u3001\u8bbe\u7f6eroot\u5bc6\u7801<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<p>\u8fd0\u884c<code>net start mysql<\/code>\u547d\u4ee4\u8ba9mysql\u542f\u52a8\u3002 <br \/>\n\uff08\u4f7f\u7528phpstudy\u7684\u8bdd\uff0c\u53ef\u4ee5\u4f7f\u7528\u63a7\u5236\u9762\u677f\u542f\u52a8\uff09<\/p>\n<\/li>\n<li>\n<p>\u8fd0\u884c<code>mysql -u root--skip-password<\/code>  \u65e0\u5bc6\u7801\u767b\u5f55mysql<\/p>\n<\/li>\n<li>\n<p>\u5728mysql\u4e0b\uff0c\u8fd0\u884c\u5982\u4e0b\u4ee3\u7801\uff0c\u4fee\u6539root\u5bc6\u7801\uff1a<\/p>\n<p>alter user&#8217;root&#8217;@&#8217;localhost&#8217;identified by &#8216;123456&#8217;;<\/p>\n<\/li>\n<li>\n<p>\u5b8c\u6bd5\uff0c\u6700\u597d\u91cd\u542f\u4e00\u4e0bmysql\u3002<\/p>\n<\/li>\n<\/ul>\n<p><wiz_tmp_tag id=\"wiz-table-range-border\" contenteditable=\"false\" style=\"display: none;\"><\/p>\n<div id=\"wiz-table-col-line\" style=\"display: none;\"><\/div>\n<div id=\"wiz-table-row-line\" style=\"display: none;\"><\/div>\n<div id=\"wiz-table-range-border_start\" style=\"display: none;\">\n<div id=\"wiz-table-range-border_start_top\"><\/div>\n<div id=\"wiz-table-range-border_start_right\"><\/div>\n<div id=\"wiz-table-range-border_start_bottom\"><\/div>\n<div id=\"wiz-table-range-border_start_left\"><\/div>\n<div id=\"wiz-table-range-border_start_dot\"><\/div>\n<\/div>\n<div id=\"wiz-table-range-border_range\" style=\"display: none;\">\n<div id=\"wiz-table-range-border_range_top\"><\/div>\n<div id=\"wiz-table-range-border_range_right\"><\/div>\n<div id=\"wiz-table-range-border_range_bottom\"><\/div>\n<div id=\"wiz-table-range-border_range_left\"><\/div>\n<div id=\"wiz-table-range-border_range_dot\"><\/div>\n<\/div>\n<p><\/wiz_tmp_tag><\/p>\n","protected":false},"excerpt":{"rendered":"<p>windows10\u4e0b\u5b89\u88c5\u89e3\u538b\u7248mysql 5.7.23 1\u3001\u89e3\u538b\u548c\u521d\u59cb\u5316\uff1a \u5b98\u7f51\u4e0b\u8f7d\uff1ahttps:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.23-winx64.zip \u89e3\u538b\u5230\u81ea\u5df1\u6253\u7b97\u5b89\u88c5\u7684\u76ee\u5f55\uff0c\u6211\u4eec\u662f\u6253\u7b97\u5347\u7ea7phpstudy2018\u7684\uff0c\u6240\u4ee5\u653e\u5728\u5982\u4e0b\u76ee\u5f55\uff1aD:\\phpStudy\\PHPTutorial\\MyS&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,93],"tags":[35,48,49,9,50],"class_list":["post-295","post","type-post","status-publish","format-standard","hentry","category-skill","category-database","tag-mysql","tag-mysql5-7-23","tag-phpstudy","tag-windows10"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":1,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":718,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions\/718"}],"wp:attachment":[{"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chenbing.name\/blog\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}