{"rsdb":{"rid":"239898","subhead":"","postdate":"0","aid":"165298","fid":"57","uid":"1","topic":"1","content":"
\n

\u524d\u8a00<\/h3> \n

\u4eca\u5929\u5b89\u88c5mysql<\/a>\u6570\u636e\u5e93<\/a>\uff0c\u8fdb\u5165mysql\u5b98\u7f51\uff0c\u5bf9\u4e8ewindows\u6765\u8bf4\u6709\u4e24\u4e2a\u7248\u672c\u7684\u6587\u4ef6\u53ef\u4e0b\u8f7d\uff0c\u4e00\u662f.msi\u5b89\u88c5\u6587\u4ef6\uff0c\u4e8c\u662f.biz\u538b\u7f29\u5305\u3002\u4ee5\u524d\u4e00\u76f4\u7528\u5b89\u88c5\u6587\u4ef6\u8fdb\u884c\u5b89\u88c5\uff0c\u767e\u8bd5\u4e0d\u723d\u3002\u4eca\u5929\u7a81\u7136\u4e0d\u60f3\u7528\u5b89\u88c5\u6587\u4ef6\u4e86\uff0c\u662f\u65f6\u5019\u7528\u538b\u7f29\u5305\u8fdb\u884c\u5b89\u88c5\u4e86\u3002\u4e8e\u662f\u4e0b\u8f7d\u4e86\u538b\u7f29\u5305\uff0c\u641c\u7d22\u4e86\u4e9b\u5b89\u88c5\u6559\u7a0b\uff0c\u5b89\u88c5\u8d77\u6765\u7684mysql\u670d\u52a1\u603b\u662f\u62a5\u9519\uff0c\u518d\u627e\u6559\u7a0b\uff0c\u8fd8\u662f\u542f\u52a8\u4e0d\u4e86\u670d\u52a1\u2026\u2026 \u4e8e\u662f\uff0c\u6211\u4e0d\u76f8\u4fe1\u767e\u5ea6\u4e86\u3002\u8fdb\u5165mysql\u5b98\u7f51\uff0c\u627e\u5230mysql5.7\u7684\u6587\u6863\uff0c\u4e00\u6b65\u4e00\u6b65\u6765\uff0c\u7ec8\u4e8e\u6210\u529f\u4e86\u3002<\/p> \n

\u4e0b\u8f7dmysql<\/h3> \n

\u8fdb\u5165\u5b98\u7f51\uff1ahttps:\/\/www.mysql.com\/<\/p> \n

\u5355\u51fb\u3010Downloads\u3011\u9009\u9879\u5361<\/p> \n

\u6700\u4e0b\u9762\u6709\u4e2a\u3010MySQL Community Edition (GPL)\u3011\uff0c\u5355\u51fb\u3010Community (GPL) Downloads »\u3011<\/p> \n

\u5355\u51fb\u3010MySQL Community Server (GPL)\u3011\u4e0b\u7684\u3010DOWNLOAD\u3011<\/p> \n

\u5728\u5f39\u51fa\u7684\u9875\u9762\u4e0a\u4e0b\u8f7d\u3010Windows (x86, 64-bit), ZIP Archive\u3011<\/p> \n

\u5b89\u88c5mysql<\/h3> \n

\u538b\u7f29\u5305\u76f8\u5f53\u4e8e\u514d\u5b89\u88c5\u6587\u4ef6\uff0c\u8981\u60f3\u4f7f\u7528\u5b83\uff0c\u9700\u8981\u914d\u7f6e\u6b63\u786e\uff0c\u5e76\u901a\u8fc7\u670d\u52a1\u6765\u542f\u52a8\u6570\u636e\u5e93\u670d\u52a1\u3002<\/p> \n

1.\u628a\u538b\u7f29\u5305\u89e3\u538b\u5230\u4f60\u559c\u6b22\u7684\u4f4d\u7f6e<\/p> \n

\u672c\u793a\u4f8b\u89e3\u538b\u5230\uff1aD:\\mysql-5.7.13-winx64\uff0c\u6587\u4ef6\u5939\u4e0b<\/p> \n

2.\u521b\u5efamy.ini\u6587\u4ef6\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p> \n

\r\n[mysqld]  \r\nport=3306  \r\nbasedir  =\u201dD:\\\\mysql-5.7.13-winx64\\\\\u201d  \r\ndatadir  =\u201dF:\\\\mysqlData\\\\\u201d  \r\n  \r\n  \r\nmax_allowed_packet = 32M  <\/pre> \n 
\r\n[mysqld]  \r\nport=3306  \r\nbasedir  ="D:\\\\mysql-5.7.13-winx64\\\\"  \r\ndatadir  ="F:\\\\mysqlData\\\\"  \r\n  \r\n  \r\nmax_allowed_packet = 32M  <\/pre> \n 

\u6ce8\u610f\uff0cbasedir\u548cdatadir\u662f\u5fc5\u987b\u8981\u914d\u7f6e\u7684\uff0cbasedir\u5c31\u662f\u4f60\u89e3\u538b\u7684\u76ee\u5f55\u3002\u5b98\u65b9\u6587\u6863\u4e0a\u8bf4\uff0c\u5982\u679c\u4f60\u559c\u6b22\u7528\u659c\u6760\uff0c\u5219\u8981\u7528\u53cc\u659c\u6760\uff0c\u53cd\u659c\u6760\u7684\u8bdd\u5c31\u4e0d\u7528\u8fd9\u6837\u3002\u5373\uff1aD:\\\\mysql-5.7.13-winx64\\\\ \u6216\uff1aD:\/mysql-5.7.13-winx64\/<\/p> \n

\u7531\u4e8e\u672c\u4eba\u559c\u6b22\u628a\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6\u72ec\u7acb\u51fa\u6765\uff0c\u6240\u4ee5\u5c31\u628adatadir\u914d\u7f6e\u5230\u5176\u5b83\u5730\u65b9\uff0c\u65b9\u4fbf\u7ba1\u7406\u3002\u53e6\u5916\uff0c\u521b\u5efa\u8be5\u76ee\u5f55\u3002<\/p> \n

3.\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/p> \n

\u6dfb\u52a0\u4e00\u4e2a\u540d\u53eb MYSQL_HOME \u7684\u53d8\u91cf\u3002<\/p> \n

\u4fee\u6539Path\u53d8\u91cf\uff0c\u5728\u672b\u5c3e\u6dfb\u52a0 %MYSQL_HOME%\\bin<\/p> \n

4.\u5b89\u88c5mysql\u670d\u52a1<\/p> \n

\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u8fd0\u884ccmd\uff0c\u8fdb\u5165mysql\u7684bin\u76ee\u5f55\u3002<\/p> \n

\u521d\u59cb\u5316\u6570\u636e\u5e93\u6587\u4ef6<\/p> \n

\r\nmysqld  \u2013initialize  <\/pre> \n 
\r\nmysqld  --initialize  <\/pre> \n 

\u521d\u59cb\u5316\u6210\u529f\u540e\uff0c\u4f1a\u5728datadir\u76ee\u5f55\u4e0b\u751f\u6210\u4e00\u4e9b\u6587\u4ef6\uff0c\u5176\u4e2d\uff0cxxx.err\u6587\u4ef6\u91cc\u8bf4\u660e\u4e86root\u8d26\u6237\u7684\u4e34\u65f6\u5bc6\u7801\u3002\u90a3\u884c\u5927\u6982\u957f\u8fd9\u6837\uff1a<\/p> \n

\r\n2016-07-24T05:19:20.152135Z 1 [Note] A temporary password is generated for root@localhost: bL2uuwuf0H(X  <\/pre> \n 
\r\n2016-07-24T05:19:20.152135Z 1 [Note] A temporary password is generated for root@localhost: bL2uuwuf0H(X <\/pre> \n 

\u5373\u5bc6\u7801\u662f\uff1abL2uuwuf0H(X<\/p> \n

\u6ce8\u518cmysql\u670d\u52a1<\/p> \n

\r\nmysqld -install MySQL  <\/pre> \n 
\r\nmysqld -install MySQL  <\/pre> \n 

\u542f\u52a8mysql\u670d\u52a1<\/p> \n

\r\nnet start MySQL  <\/pre> \n 
\r\nnet start MySQL  <\/pre> \n 

\u4fee\u6539root\u5bc6\u7801<\/p> \n

\r\nmysql -u root -p  <\/pre> \n 
\r\nmysql -u root -p  <\/pre> \n 
\r\nALTER USER \u2018root\u2019@\u2018localhost\u2019 IDENTIFIED BY \u2018new_password\u2019;  <\/pre> \n 
\r\nALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';  <\/pre> \n<\/div>","orderid":"0","title":"windows64\u4f4d\u7cfb\u7edf\u4e0b\u7528\u538b\u7f29\u5305\u5b89\u88c5mysql\u6570\u636e\u5e93\u7684\u8be6\u7ec6\u6559\u7a0b","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"140","pages":"1","comments":"0","posttime":"2017-10-20 08:14:18","list":"1508458458","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"windows64<\/A> \u7cfb\u7edf<\/A> \u538b\u7f29<\/A> \u5b89\u88c5<\/A> mysql<\/A> \u6570\u636e\u5e93<\/A> \u8be6\u7ec6<\/A> \u6559\u7a0b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"113.108.110.181","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"windows64\u4f4d\u7cfb\u7edf\u4e0b\u7528\u538b\u7f29\u5305\u5b89\u88c5mysql\u6570\u636e\u5e93\u7684\u8be6\u7ec6\u6559\u7a0b","lastview":"1712990102","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}