mysql zip 安裝

標籤：

電腦中存的是mysql_5.6.24版本的。安裝過程中遇到些麻煩，記錄一下。

一開始去官網上下載了最新的5.7.12版的，一直啟動不了mysql的服務。發現原因是，電腦中本來安裝了5.6.24版本的，有衝突了應該。5.7.12版的解壓後沒有data目錄，很蛋疼，也沒有找到解決方案，網上說要在一開始執行一條命令。以後還是去官網看說明吧。這個暫時不看了。

然後就直接安裝5.6.24版本的，可是也是一直安裝不成功，這裡就要注意設定檔的書寫格式。

mysql預設讀取的是安裝目錄下的my.ini檔案。

可以看一下這篇部落格：http://www.cnblogs.com/freeton/p/4264829.html

最簡單的配置方式就是改一下根目錄和資料檔案存放目錄。

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/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.#mysql根目錄 basedir ="C:\Program Files\mysql-5.6.22-win32"#資料檔案存放目錄 datadir ="C:\Program Files\mysql-5.6.22-win32\data"# port = .....   連接埠，預設3306# server_id = .....  服務執行個體的唯一標識# 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 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #服務端的編碼方式character-set-server=utf8[client]#用戶端編碼方式，最好和服務端儲存一致loose-default-character-set = utf8[WinMySQLadmin]  Server = "C:\Program Files\mysql-5.6.22-win32\bin\mysqld.exe"

　　

mysql zip 安裝