mysql-5.6.40-win64安装配置简介

最近由于换电脑，之前的开发环境没了，不得不又重新配置mysql，下载了mysql-5.6.40-winx64.zip。但是安装之后一直启动不了。

于是借鉴了之前电脑上安装的mysql目录下的文件，终于把mysql安装配置完成了。下面简单的总结下，给大家做个参考

1 解压缩mysql-5.6.27a-win64到目录D:Program Filesmysql-5.6.40-winx64中

2 创建环境变量MYSQL_HOME=D:Program Files\mysql-5.6.40-winx64

 

在path变量后添加;%MYSQL_HOME%in

3 编辑"D:Program Filesmysql-5.6.40-winx64my.ini"

[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 = .....

[mysql]

# 设置mysql客户端默认字符集

default-character-set=utf8

[mysqld]

#设置3306端口port = 3306

# 设置mysql的安装目录

basedir=E:/Program Files/mysql-5.6.40-winx64

# 设置mysql数据库的数据的存放目录

datadir=E:/Program Files/mysql-5.6.40-winx64/data

# 允许最大连接数

max_connections=200

# 服务端使用的字符集默认为8比特编码的latin1字符集

character-set-server=utf8

# 创建新表时将使用的默认存储引擎

default-storage-engine=INNODB

# 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

4 进入DOS窗口到运行如下命令启动安装程序

mysqld --install mysql --defaults-file="D:Program Filesmysql-5.6.40-winx64my.ini"

其他命令：

• 删除系统服务

mysqld --remove mysql

• 启动和关闭系统服务

net start mysql

net stop mysql

• 登陆root用户并修改密码

#mysql -u root -p

#Enter Password: //不输入直接回车默认密码

#use mysql

#update user set password=PASSWORD('123456') where user='root'; //输入(注意后面的分号要加上)：

#flush privileges;