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