window系统安装MYSQL8.0版本完整版
window系统安装mysql8.0完整版
！！！！本人修改了mysql的端口号3308，可以自己修改my.ini文件中的配置
一、下载两个版本的MySQL
进入官网下载：https://www.mysql.com/
二、将下载下来的压缩包放到合适的位置并且解压缩
注意：此处先解压安装MySQL8时再解压8.0版本（要不然容易出问题）
配置环境变量
安装MySQL8
1、先创建my.ini文件
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3308
[mysql]
default-character-set=utf8
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3308
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/workmenus/MySQL8/MySQL8/mysql-8.0.19-winx64"
#Path to the database root
datadir="D:/workmenus/MySQL8/MySQL8/mysql-8.0.19-winx64/Data/"
# 允许最大连接数
max_connections=10000
# 允许最大连接人数
max_user_connections=1000
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 连接时间
wait_timeout=31536000
interactive_timeout=31536000
2、生成data文件夹
以管理员身份打开cmd命令提示符，切换到MySQL8的 bin 路径下。
输入命令：mysqld --initialize
等一段时间，它会重新生成一个 Data 文件夹
同样找到.err文件，找到对应生成的随机密码
3、安装MySQL8服务
在命令行输入 (名字命名为MYSQL8,并且指定默认的配置文件为刚才创建的my.ini文件)
mysqld --install MYSQL8 --defaults-file=D:\workmenus\MySQL8\MySQL8\mysql-8.0.19-winx64\my.ini
4、开启MySQL8服务
在命令行输入 net start MYSQL8
5、登录MYSQL8,并且修改密码
（1）登录输入：mysql -u root -P 3308 -h localhost -p
密码输入 .err文件里的生成的随机密码
（2）修改密码输入:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
6、链接成功
