Windows安装MySQL

下载

https://downloads.mysql.com/archives/community/

安装

1. 解压下载后的文件
2. 创建my.ini文件，需要修改一下basedir和datadir

[mysqld]
#主从同步配置，主机是1从机从2开始
server-id=1
port = 3306
character_set_server=utf8mb4
basedir=D:/soft/mysql-5.7.26-winx64/mysql-5.7.26-winx64
datadir=D:/soft/mysql-5.7.26-winx64/mysql-5.7.26-winx64/data

default-storage-engine=INNODB

join_buffer_size = 512M
tmp_table_size = 1G
max_allowed_packet = 100M
interactive_timeout = 1800
#默认8小时
wait_timeout = 1800
read_buffer_size = 128M
read_rnd_buffer_size = 256M
sort_buffer_size = 256M
key_buffer_size=512M
back_log=500
flush_time=0
open_files_limit=4161
table_definition_cache=1400
binlog_row_event_max_size=16M


# MySQL服务器最大连接数
max_connections=1000
max_connect_errors = 1000

# MySQL服务器线程缓存大小
thread_cache_size=500

# 日志缓冲刷新的频繁程度
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=2G
innodb_log_file_size=512M
innodb_log_buffer_size=256M
innodb_thread_concurrency=32
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
innodb_lock_wait_timeout = 50


#瓶颈位，即使在并发量不高的时候也会出现，最好的选择是从一开始就禁用它
query_cache_size = 0

slow-query-log=1
long_query_time=10

lower_case_table_names=1
table_open_cache=4096

autocommit = 1
skip_name_resolve = 1
transaction_isolation = READ-COMMITTED
explicit_defaults_for_timestamp = 1

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

ft_min_word_len=2


#开启二进制日志
#log_bin = "C:/mysql-5.7.26-winx64/log/mysql-bin"
#log_bin_index = mysql-bin.index
#binlog_format = ROW
#expire_logs_days = 1
#binlog_cache_size=32m
#max_binlog_cache_size=512m
#max_binlog_size=512m
#binlog_ignore_db = mysql
#log-bin=C:/mysql-5.7.26-winx64/log/mysql-bin
#binlog-do-db=rainbow
#binlog-do-db=meteordb2
#binlog-do-db=kyubi_exec
#binlog-do-db=kyubi_tianhe

1. bin目录 初始化 mysqld --initialize-insecure
   

配置环境变量

MYSQL_HOME

启动

mysqld --install
net start mysql

设置密码

1. net stop mysql
2. mysqld --skip-grant-tables
3. 用管理员再打开一个命令窗口，切换到mysql/bin目录
4. mysql -u root
5. use mysql
6. update user set authentication_string=password(‘123456’)where user=‘root’;
7. flush privileges;
8. quit;
   
   

再启动 出现发生系统错误 5

切换到Windows/System32目录下用管理员打开cmd启动成功