{"id":220,"date":"2019-07-29T18:27:54","date_gmt":"2019-07-29T10:27:54","guid":{"rendered":"http:\/\/www.sttxx.com\/?p=220"},"modified":"2019-07-29T18:27:55","modified_gmt":"2019-07-29T10:27:55","slug":"win10anzhuangmysql8","status":"publish","type":"post","link":"http:\/\/www.sttxx.com\/index.php\/2019\/07\/29\/win10anzhuangmysql8\/","title":{"rendered":"win10\u5b89\u88c5mysql8"},"content":{"rendered":"\n<p>MySQL 8.0 Server\u8981\u6c42Microsoft Visual C ++ 2015 Redistributable Package\u5728Windows\u5e73\u53f0\u4e0a\u8fd0\u884c\u3002\u5728\u5b89\u88c5\u670d\u52a1\u5668\u4e4b\u524d\uff0c\u8bf7\u786e\u4fdd\u5df2\u5728\u7cfb\u7edf\u4e0a\u5b89\u88c5\u8be5\u8f6f\u4ef6\u5305\u3002\u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/www.microsoft.com\/zh-CN\/download\/details.aspx?id=48145\">Microsoft\u4e0b\u8f7d\u4e2d\u5fc3<\/a><\/p>\n\n\n\n<ul><li>mysql \u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/dev.mysql.com\/downloads\/mysql\/\">\u4e0b\u8f7d<\/a><\/li><\/ul>\n\n\n\n<p>\u9009\u62e9\u7248\u672c\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"924\" height=\"568\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-10.png\" alt=\"\" class=\"wp-image-225\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-10.png 924w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-10-300x184.png 300w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-10-768x472.png 768w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<ul><li>\u89e3\u538b\uff0c\u5e76\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/li><\/ul>\n\n\n\n<p>\u684c\u9762\u9009\u4e2d\u6211\u7684\u7535\u8111\u53f3\u952e&#8211;>\u5c5e\u6027&#8211;>\u9ad8\u7ea7\u7cfb\u7edf\u8bbe\u7f6e&#8211;>\u73af\u5883\u53d8\u91cf&#8211;>Path&#8211;>\u7f16\u8f91&#8211;>\u65b0\u5efa<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"494\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-11-1024x494.png\" alt=\"\" class=\"wp-image-226\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-11-1024x494.png 1024w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-11-300x145.png 300w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-11-768x370.png 768w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-11.png 1207w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul><li>\u5728\u89e3\u538b\u76ee\u5f55\u4e0b\u65b0\u5efamy.ini\u914d\u7f6e\u6587\u4ef6\uff1a<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\n# \u8bbe\u7f6e3306\u7aef\u53e3\nport=3306\n# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55\nbasedir=D:\/Program Files\/mysql-8.0.17-winx64\n# \u8bbe\u7f6emysql\u6570\u636e\u5e93\u7684\u6570\u636e\u7684\u5b58\u653e\u76ee\u5f55\ndatadir=D:\/ProgramData\/MySQL\/MySQL8\/Data\n# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570\nmax_connections=200\n# \u5141\u8bb8\u8fde\u63a5\u5931\u8d25\u7684\u6b21\u6570\u3002\u8fd9\u662f\u4e3a\u4e86\u9632\u6b62\u6709\u4eba\u4ece\u8be5\u4e3b\u673a\u8bd5\u56fe\u653b\u51fb\u6570\u636e\u5e93\u7cfb\u7edf\nmax_connect_errors=10\n# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3aUTF8\ncharacter-set-server=utf8\n# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\ndefault-storage-engine=INNODB\n# \u9ed8\u8ba4\u4f7f\u7528\u201cmysql_native_password\u201d\u63d2\u4ef6\u8ba4\u8bc1\ndefault_authentication_plugin=mysql_native_password\n[mysql]\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6\ndefault-character-set=utf8\n[client]\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u8fde\u63a5\u670d\u52a1\u7aef\u65f6\u9ed8\u8ba4\u4f7f\u7528\u7684\u7aef\u53e3\nport=3306\ndefault-character-set=utf8<\/code><\/pre>\n\n\n\n<p>basedir\u548cdatadir\u6309\u7167\u5b9e\u9645\u60c5\u51b5\u586b\u5199<\/p>\n\n\n\n<ul><li>\u5b89\u88c5MySQL<\/li><\/ul>\n\n\n\n<p>\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u8fd0\u884ccmd<br> \u6267\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqld install<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"352\" height=\"62\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-6.png\" alt=\"\" class=\"wp-image-221\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-6.png 352w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-6-300x53.png 300w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/figure>\n\n\n\n<p>Mysql\u521d\u59cb\u5316<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqld --initialize --console<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"169\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-8-1024x169.png\" alt=\"\" class=\"wp-image-223\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-8-1024x169.png 1024w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-8-300x50.png 300w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-8-768x127.png 768w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-8.png 1029w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u542f\u52a8MySQL\u670d\u52a1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>net start mysql<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"519\" height=\"137\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-7.png\" alt=\"\" class=\"wp-image-222\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-7.png 519w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-7-300x79.png 300w\" sizes=\"(max-width: 519px) 100vw, 519px\" \/><\/figure>\n\n\n\n<p>\u767b\u5f55mysql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"662\" height=\"303\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-9.png\" alt=\"\" class=\"wp-image-224\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-9.png 662w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-9-300x137.png 300w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/figure>\n\n\n\n<ul><li>\u914d\u7f6eMySQL\u7528\u6237<\/li><\/ul>\n\n\n\n<p>\u4fee\u6539\u7528\u6237\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '\u65b0\u5bc6\u7801';<\/code><\/pre>\n\n\n\n<p>\u521b\u5efa\u7528\u6237\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'abc'@'%' IDENTIFIED WITH mysql_native_password BY 'abc';<\/code><\/pre>\n\n\n\n<p>\u68c0\u67e5\u7528\u6237<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select user, host, plugin, authentication_string from user;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"891\" height=\"348\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-14.png\" alt=\"\" class=\"wp-image-229\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-14.png 891w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-14-300x117.png 300w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-14-768x300.png 768w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/figure>\n\n\n\n<p>\u6388\u6743\u8fdc\u7a0b\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO 'abc'@'%';<\/code><\/pre>\n\n\n\n<p>\u67e5\u770b\u7528\u6237\u6743\u9650<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show grants for 'abc'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"344\" src=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-15-1024x344.png\" alt=\"\" class=\"wp-image-230\" srcset=\"http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-15-1024x344.png 1024w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-15-300x101.png 300w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-15-768x258.png 768w, http:\/\/www.sttxx.com\/wp-content\/uploads\/2019\/07\/image-15.png 1089w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MySQL 8.0 Server\u8981\u6c42Microsoft Visual C ++ <\/p>\n","protected":false},"author":1,"featured_media":224,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[58],"tags":[59,55],"_links":{"self":[{"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/posts\/220"}],"collection":[{"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/comments?post=220"}],"version-history":[{"count":1,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/posts\/220\/revisions"}],"predecessor-version":[{"id":231,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/posts\/220\/revisions\/231"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/media\/224"}],"wp:attachment":[{"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/media?parent=220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/categories?post=220"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sttxx.com\/index.php\/wp-json\/wp\/v2\/tags?post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}