本地Windows上安装 MySQL数据库

1、首先下载mysql安装文件，下载地址：https://dev.mysql.com/downloads/mysql/

2、将下载下来的压缩包解压到本地一个文件夹中

3、在文件根目录下新增my.ini文件，配置以下信息：

[mysql]

设置mysql客户端默认字符集

default-character-set=utf8
[mysqld]
#设置3306端口
port = 3306

设置mysql的安装目录

basedir=C:\mysql-8.0.13-winx64

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

datadir=C:\mysql-8.0.13-winx64\sqldata

允许最大连接数

max_connections=20

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

character-set-server=utf8

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

default-storage-engine=INNODB

#skip-grant-tables
wait_timeout=1814400

4、以管理员身份打开 cmd 命令行工具，切换目录：

cd C:\mysql-8.0.13-winx64\bin
输入以下安装命令：
mysqld install
初始化，在 5.7之后 需要初始化 data 目录：
mysqld --initialize-insecure
启动输入以下命令即可：
net start mysql

5、登录mysql：
在CMD窗口，输入：
mysql -u root -p 回车
密码为空

6、更改mysql连接密码：

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #修改加密规则 （这行我没有写，不过貌似也可以）

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新一下用户的密码

FLUSH PRIVILEGES; #刷新权限

扩展信息(卸载mysql)：

先停止服务：
net stop mysql

再进行移除：
mysqld --remove mysql
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/1
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/1?5FBHr
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/1?vxjhv
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/1?53517
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/2
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/2?64ksU
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/2?cmiyw
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/2?64608
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/3
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/3?nXx73
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/3?njjpr
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/3?75315
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/4
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/4?J3jnR
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/4?fdjjv
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/4?53377
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/5
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/5?v3FJ7
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/5?dvllf
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/5?57719
https://github.com/q39717774/lzpwfxiwmu/issues/1
https://github.com/q39717774/lzpwfxiwmu/issues/1?O0kw6
https://github.com/q39717774/lzpwfxiwmu/issues/1?acscq
https://github.com/q39717774/lzpwfxiwmu/issues/1?06882
https://github.com/q39717774/lzpwfxiwmu/issues/2
https://github.com/q39717774/lzpwfxiwmu/issues/2?nntvr
https://github.com/q39717774/lzpwfxiwmu/issues/2?pfzzz
https://github.com/q39717774/lzpwfxiwmu/issues/2?53335
https://github.com/q39717774/lzpwfxiwmu/issues/3
https://github.com/q39717774/lzpwfxiwmu/issues/3?vzrdf
https://github.com/q39717774/lzpwfxiwmu/issues/3?pnlnp
https://github.com/q39717774/lzpwfxiwmu/issues/3?71195
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/6
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/6?rVFvB
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/6?vhjrr
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/6?91733
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/7
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/7?oIMqe
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/7?qkses
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/7?46802
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/8
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/8?0K44u
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/8?csymm
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/8?02004
https://github.com/q39717774/lzpwfxiwmu/issues/4
https://github.com/q39717774/lzpwfxiwmu/issues/4?68g4M
https://github.com/q39717774/lzpwfxiwmu/issues/4?mgqum
https://github.com/q39717774/lzpwfxiwmu/issues/4?28446
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/9
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/9?iOaw4
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/9?ickia
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/9?86484
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/10
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/10?9l1V9
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/10?lrlhb
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/10?17999
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/11
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/11?oA242
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/11?aywmc
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/11?60404
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/12
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/12?6cm8G
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/12?wsago
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/12?42262
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/13
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/13?9v7vx
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/13?fnhbx
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/13?13539
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/14
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/14?d511t
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/14?jlnxz
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/14?95793
https://github.com/q39717774/lzpwfxiwmu/issues/5
https://github.com/q39717774/lzpwfxiwmu/issues/5?F17xn
https://github.com/q39717774/lzpwfxiwmu/issues/5?xhhnv
https://github.com/q39717774/lzpwfxiwmu/issues/5?75757
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/15
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/15?x7JZf
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/15?fxbdp
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/15?33155
https://github.com/q39717774/lzpwfxiwmu/issues/6
https://github.com/q39717774/lzpwfxiwmu/issues/6?68q6Y
https://github.com/q39717774/lzpwfxiwmu/issues/6?ykqsa
https://github.com/q39717774/lzpwfxiwmu/issues/6?60622
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/16
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/16?8a80S
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/16?ogims
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/16?66244
https://github.com/q39717774/lzpwfxiwmu/issues/7
https://github.com/q39717774/lzpwfxiwmu/issues/7?6caWg
https://github.com/q39717774/lzpwfxiwmu/issues/7?yamek
https://github.com/q39717774/lzpwfxiwmu/issues/7?06068
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/17
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/17?yIW0Y
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/17?ocoie
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/17?88688
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/18
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/18?VhXlV
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/18?nblpd
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/18?95371
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/19
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/19?bp5z1
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/19?txhvv
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/19?71513
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/20
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/20?r7LZn
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/20?vzvxd
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/20?57513
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/21
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/21?9p9B1
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/21?phzrt
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/21?31139
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/22
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/22?0M2ik
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/22?imkio
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/22?24200
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/23
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/23?iIYIC
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/23?kswwk
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/23?42804
https://github.com/q39717774/lzpwfxiwmu/issues/8
https://github.com/q39717774/lzpwfxiwmu/issues/8?28QkG
https://github.com/q39717774/lzpwfxiwmu/issues/8?ysugo
https://github.com/q39717774/lzpwfxiwmu/issues/8?66448
https://github.com/q39717774/lzpwfxiwmu/issues/9
https://github.com/q39717774/lzpwfxiwmu/issues/9?ssg8c
https://github.com/q39717774/lzpwfxiwmu/issues/9?sysoe
https://github.com/q39717774/lzpwfxiwmu/issues/9?28404
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/24
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/24?28422
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/24?kqwmm
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/24?40666
https://github.com/q39717774/lzpwfxiwmu/issues/10
https://github.com/q39717774/lzpwfxiwmu/issues/10?q468O
https://github.com/q39717774/lzpwfxiwmu/issues/10?eisku
https://github.com/q39717774/lzpwfxiwmu/issues/10?86684
https://github.com/q39717774/lzpwfxiwmu/issues/11
https://github.com/q39717774/lzpwfxiwmu/issues/11?R7vvn
https://github.com/q39717774/lzpwfxiwmu/issues/11?pnplv
https://github.com/q39717774/lzpwfxiwmu/issues/11?13775
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/25
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/25?q8YU2
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/25?qaqkg
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/25?66406
https://github.com/q1851767944/hndzpppfvx/issues/1
https://github.com/q1851767944/hndzpppfvx/issues/1?d39dR
https://github.com/q1851767944/hndzpppfvx/issues/1?vzrlx
https://github.com/q1851767944/hndzpppfvx/issues/1?93139
https://github.com/q1851767944/hndzpppfvx/issues/2
https://github.com/q1851767944/hndzpppfvx/issues/2?4Dp09
https://github.com/q1851767944/hndzpppfvx/issues/2?yjvoh
https://github.com/q1851767944/hndzpppfvx/issues/2?07403
https://github.com/q1851767944/hndzpppfvx/issues/3
https://github.com/q1851767944/hndzpppfvx/issues/3?rT35V
https://github.com/q1851767944/hndzpppfvx/issues/3?vrjzp
https://github.com/q1851767944/hndzpppfvx/issues/3?53993
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/26
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/26?s06qw
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/26?oqaiq
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/26?20288
https://github.com/q1851767944/hndzpppfvx/issues/4
https://github.com/q1851767944/hndzpppfvx/issues/4?0Uw08
https://github.com/q1851767944/hndzpppfvx/issues/4?qukgy
https://github.com/q1851767944/hndzpppfvx/issues/4?62020
https://github.com/q1851767944/hndzpppfvx/issues/5
https://github.com/q1851767944/hndzpppfvx/issues/5?bNZ91
https://github.com/q1851767944/hndzpppfvx/issues/5?ldvbh
https://github.com/q1851767944/hndzpppfvx/issues/5?79573
https://github.com/q1851767944/hndzpppfvx/issues/6
https://github.com/q1851767944/hndzpppfvx/issues/6?4Js1Z
https://github.com/q1851767944/hndzpppfvx/issues/6?wldfu
https://github.com/q1851767944/hndzpppfvx/issues/6?32548
https://github.com/q1851767944/hndzpppfvx/issues/7
https://github.com/q1851767944/hndzpppfvx/issues/7?42Wk8
https://github.com/q1851767944/hndzpppfvx/issues/7?cyawc
https://github.com/q1851767944/hndzpppfvx/issues/7?24466
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/27
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/27?82k0I
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/27?weios
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/27?06068
https://github.com/q1851767944/hndzpppfvx/issues/8
https://github.com/q1851767944/hndzpppfvx/issues/8?E028c
https://github.com/q1851767944/hndzpppfvx/issues/8?seeku
https://github.com/q1851767944/hndzpppfvx/issues/8?04866
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/28
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/28?866WE
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/28?ocauk
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/28?88260
https://github.com/q1851767944/hndzpppfvx/issues/9
https://github.com/q1851767944/hndzpppfvx/issues/9?DRDfX
https://github.com/q1851767944/hndzpppfvx/issues/9?bhnvp
https://github.com/q1851767944/hndzpppfvx/issues/9?79355
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/29
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/29?1x35l
https://github.com/sjkivcalhx/lzlxzdnzbx/issues/29?lnppt