windows mysql5.7.23 压缩包安装

1.下载mysql5.7.23

2. 配置 my.ini

basedir 和 datadir 切换成自己的目录

  		[mysqld]
explicit_defaults_for_timestamp=true
port=3306
basedir=C:\\tol\\mysql-5.7.23-winx64-service\\mysql-5.7.23-winx64
datadir=C:\\tol\\mysql-5.7.23-winx64-service\\mysql-5.7.23-winx64\\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
innodb_buffer_pool_size = 256M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = normal
[mysql]
default-character-set=utf8

3. 命令行安装

以管理员身份运行cmd

   1. 进入mysql basedir \bin 目录下
   2. 执行 mysqld -install
   3. 执行 mysqld --initialize-insecure --user=mysql
   4. 执行 net start mysql