mysql5.7.14解压版windows下安装方法

话不多说，直接解压mysql-5.7.14-winx64.zip到D:\Program Files重全名为mysql

新建数据存放文件data

修改my-default.ini为my.ini

打开my.ini找到basedir与datadir两项，去掉注释并把两项的值分别设置为basedir = D:\Program Files\mysql与datadir = D:\Program Files\mysql\data

添加环境变量D:\Program Files\mysql\bin

以管理员身份运行cmd程序并到D:\Program Files\mysql\bin文件夹下执行命令mysqld --initialize-insecure --user=mysql这句话是初始化数据库；mysqld -install [服务名]把mysql安装为服务

启动mysql命令net start mysql

登录mysql命令mysql -u root -p 第一次登录没有密码

修改密码mysqladmin -uroot -p password root把mysql的root用户密码修改为root

用mysql -u root -p再次登录

basedir = D:\Program Files\mysql
datadir = D:\Program Files\mysql\data
log_bin = D:\Program Files\mysql\logbin\mysql-bin
binlog_format = mixed
event_scheduler = 1
socket = D:\Program Files\mysql\mysql.sock
log_error = D:\Program Files\mysql\data\windows.err
log_warnings = 0
# port = .....
server-id = 1
innodb_file_per_table = 1
lower_case_table_names = 1

character-set-server=utf8 #服务器默认编码
collation-server=utf8_general_ci #服务器默认编码排序

# 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