Mysql 5.7.11压缩版安装及问题解决

1、在官网下下mysql最新版，下载时需要登录账号，没有的需要先注册

http://dev.mysql.com/downloads/mysql/

2、下载后解压至D:\Program Files (x86)

3、在D:\Program Files (x86)\mysql-5.7.11-winx64 目录下创建 my.ini

my.ini内容是

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8 
[mysqld]
#设置3306端口
port = 3306 
# 设置mysql的安装目录
basedir="D:\Program Files (x86)\mysql-5.7.11-winx64"
# 设置mysql数据库的数据的存放目录
datadir="E:\mysql\data"
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB 

注意：由于第一次使用时root用户没有密码，此文件末尾需要添加一行 skip-grant-tables

 登录后马上修改密码

UPDATE user SET authentication_string= password ('123456') WHERE User='root';

修改完成后，删除该语句

在my.ini 中加入：default_password_lifetime=0 ，设置为：0 表示密码永不过期

4、win+x快捷键选择【命令提示符(管理员)】，进入D:\Program Files (x86)\mysql-5.7.11-winx64\bin

5、执行mysqld -install

6、初始化data目录，执行命令：mysqld  --initialize，由于楼主下载的是最新版，压缩文件夹下没有data目录，需要初始化，不然mysql不能启动

7、启动服务 net start mysql

mysql相关命令整理：

mysqld -install：安装服务

mysqld  --initialize：初始化data目录

mysqld --console：日志打印，当服务不能启动时，可以通过此命令查看日志

楼主在安装时，没有初始化data目录一直不能启动，这个问题解决了好久，网上说5.6.*的版本可以成功，是因为5.6.*的压缩文件中自带data目录

错误界面：

016-03-20T05:30:30.676967Z 0 [Note] Binlog end
2016-03-20T05:30:30.678965Z 0 [Note] Shutting down plugin 'ngram'
2016-03-20T05:30:30.681966Z 0 [Note] Shutting down plugin 'partition'
2016-03-20T05:30:30.683971Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-20T05:30:30.686973Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-20T05:30:30.688988Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-20T05:30:30.689974Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-20T05:30:30.691973Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-20T05:30:30.692974Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-20T05:30:30.696993Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-20T05:30:30.698979Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-20T05:30:30.699996Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-20T05:30:30.701981Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-20T05:30:30.702983Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-20T05:30:30.708001Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-20T05:30:30.708985Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-20T05:30:30.710987Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-20T05:30:30.713990Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-20T05:30:30.715992Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-20T05:30:30.716992Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-20T05:30:30.718004Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-20T05:30:30.718992Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-20T05:30:30.720994Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-20T05:30:30.722007Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-20T05:30:30.723008Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-20T05:30:30.723997Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-20T05:30:30.724998Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-20T05:30:30.725997Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-20T05:30:30.726998Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-20T05:30:30.731001Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-20T05:30:30.733003Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-20T05:30:30.735004Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-20T05:30:30.736004Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-20T05:30:30.737006Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-20T05:30:30.737006Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-20T05:30:30.738007Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-20T05:30:30.739007Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-20T05:30:30.740007Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-20T05:30:30.740007Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-20T05:30:30.741009Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-20T05:30:30.742009Z 0 [Note] InnoDB: Starting shutdown...
2016-03-20T05:30:30.843488Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\Program Files (x86)\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-20T05:30:30.856566Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160320 13:30:30
2016-03-20T05:30:32.107104Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209980
2016-03-20T05:30:32.113109Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-20T05:30:32.125112Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-20T05:30:32.127115Z 0 [Note] Shutting down plugin 'CSV'
2016-03-20T05:30:32.129133Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-20T05:30:32.131134Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-20T05:30:32.133134Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-20T05:30:32.135136Z 0 [Note] Shutting down plugin 'binlog'
2016-03-20T05:30:32.137137Z 0 [Note] mysqld: Shutdown complete