一、MySQL的安裝和初始化

1. mysql安裝包下載地址
   https://dev.mysql.com/downloads/mysql/
   Community_MySQL on Windows_Generally Available(GA)Releases(通用版) 選用
   Development Releases（開發(fā)版）研究用

2.MySQL 客戶端工具
SQLyog Ultimate
HeidiSQL
navicat for mysql

3.壓縮包安裝方式

從官網(wǎng)上下載mysql-5.6.31-winx64.zip,將其解壓，接下來的安裝是通過命令來安裝MySQL數(shù)據(jù)庫的。

(1)mysql-5.6.31-winx64.zip解壓到E:\JavaWebDeveloper\文件下，打開命令提示符以管理員身份運行，cd到E:\JavaWebDeveloper\mysql-5.6.31-winx64\bin下
命令為：cd /d E:\JavaWebDeveloper\mysql-5.6.31-winx64\bin

1.png

(2)安裝MySQL
mysqld install，運行命令后MySQL安裝成功。

2.png

(3)啟動MySQL服務(wù)。
net start mysql將啟動MySQL服務(wù)。值得注意的是用命令安裝的MySQL在Windows系統(tǒng)下默認(rèn)服務(wù)名為mysql，默認(rèn)密碼為空。

3.png

(4)配置環(huán)境變量
1)新建MYSQL_HOME變量，并配置值為:E:\JavaWebDeveloper\mysql-5.6.31-winx64
MYSQL_HOME：E:\JavaWebDeveloper\mysql-5.6.31-winx64
2)編輯path系統(tǒng)變量，將%MYSQL_HOME%\bin添加到path變量后。配置path環(huán)境變量，也可不新建MYSQL_HOME變量，而是直接將MySQL安裝目錄下的bin配置到path變量下，
Path：%MYSQL_HOME%\bin

4.png

5.png

(5)進(jìn)入MySQL
mysql -u root -p，密碼默認(rèn)為空。顯示“mysql>”表示進(jìn)入MySQL，可用T-SQL語句對數(shù)據(jù)庫執(zhí)行各種操作。也可用數(shù)據(jù)庫圖形化管理工具對數(shù)據(jù)庫進(jìn)行管理

6.png

二、net start mysql 服務(wù)無法啟動

MySQL 5.7.20 net start mysql 服務(wù)無法啟動-“NET HELPMSG 3534” 的奇怪問題 http://blog.csdn.net/ender__/article/details/53689804

執(zhí)行mysqld --initialize-insecure出現(xiàn)錯誤提示

C:\WINDOWS\system32>mysqld --initialize-insecure
mysqld: Can't create directory 'D:\Program Files oft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\data' (Errcode: 2 - No such file or directory)
2016-12-16T02:12:53.583901Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-16T02:12:53.583901Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-12-16T02:12:53.583901Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-12-16T02:12:53.583901Z 0 [ERROR] Can't find error-message file 'D:\Program Files oft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2016-12-16T02:12:53.583901Z 0 [ERROR] Aborting

只好把目錄改成反斜杠 在mysql-5.7.14-winx64\下面創(chuàng)建my.ini文件，如下
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64

解壓目錄

datadir=D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64/data

解壓目錄下data目錄

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64/bin/mysqld.exe

再次執(zhí)行成功
C:\WINDOWS\system32> mysqld install MySQL --defaults-file="D:\Program Files\soft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\my.ini"
Service successfully installed.
C:\WINDOWS\system32>net start mysql

MySQL 服務(wù)正在啟動 .
MySQL 服務(wù)已經(jīng)啟動成功