這篇文章給大家詳細介紹了mysql 5.7.17免安裝配置教程，首先大家需要先下載mysql 5.7.17 的安裝包，然后解壓，具體配置過程大家通過本文一起學習吧
1、下載mysql-5.7.17-winx64.zip安裝包
2、解壓安裝包。
D:DevelopToolmysql-5.7.17-winx64?? #解壓目錄
3、在解壓目錄下創建一個名為data的文件夾，用來存放數據
D:DevelopToolmysql-5.7.17-winx64data
4、配置啟動文件
把 D:DevelopToolmysql-5.7.17-winx64my-default.ini 文件copy一份，重新命名為 my.ini ，修改里面的參數，如下：
#?For?advice?on?how?to?change?settings?please?see #?http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html #?***?DO?NOT?EDIT?THIS?FILE.?It's?a?template?which?will?be?copied?to?the #?***?default?location?during?install,?and?will?be?replaced?if?you #?***?upgrade?to?a?newer?version?of?MySQL. [mysqld] #?Remove?leading?#?and?set?to?the?amount?of?RAM?for?the?most?!important?data #?cache?in?MySQL.?Start?at?70%?of?total?RAM?for?dedicated?server,?else?10%. #?innodb_buffer_pool_size?=?128M #?Remove?leading?#?to?turn?on?a?very?important?data?integrity?option:?logging #?changes?to?the?binary?log?between?backups. #?log_bin #?These?are?commonly?set,?remove?the?#?and?set?as?required. #?basedir?=?..... #?datadir?=?..... #?port?=?..... #?server_id?=?..... ######################### #?basedir?為安裝文件解壓后的目錄?｜?basedir和datadir?可以使用相對路徑 #?basedir=./.. basedir=D:DevelopToolmysql-5.7.11-winx64 #?datadir?為用來存放數據的目錄 #?datadir=./../data datadir=D:DevelopToolmysql-5.7.11-winx64data #?port?為端口號 port=3306 #?mar_connections為最大連接數 max_connections=20 character_set_server=utf8 #?Remove?leading?#?to?set?options?mainly?useful?for?reporting?servers. #?The?server?defaults?are?faster?for?transactions?and?fast?SELECTs. #?Adjust?sizes?as?needed,?experiment?to?find?the?optimal?values. #?join_buffer_size?=?128M #?sort_buffer_size?=?2M #?read_rnd_buffer_size?=?2M? explicit_defaults_for_timestamp=true sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
?5、初始化數據目錄
mysqld?--defaults-file="D:DevelopToolmysql-5.7.17-winx64my.ini"?--initialize-insecure
它會初始化 data 目錄，在執行此命令前請先把data目錄下的所有文件先刪除，否則會失敗
可以選擇用 –initialize-insecure 或者 –initialize 來初始化，–initialize-insecure 初始化root密碼為空，如果用 –initialize來初始化，會產生一個隨機密碼
執行成功后，在data目錄下會生成mysql，perofrmance_schema，sys等目錄文件
6、安裝和啟動mysql服務
#安裝服務 mysqld?-install #啟動服務 net?start?mysql #進入mysql mysql?-u?root?-p #移除mysql mysqld?-remove
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
