這篇文章給大家詳細介紹了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