分享一下我在mysql5.6+mysql8数据库安装过程中的一些坑！

1 INSERT INTO mysql.user (Host,User,Password) VALUES ('%','system', PASSWORD('root'));
2 FLUSH PRIVILEGES;

方法1： 用SET PASSWORD命令
格式：mysql> set password for 用户名@localhost = password('新密码');
例子：mysql> set password for root@localhost = password('123');
方法2：用mysqladmin
格式：mysqladmin -u用户名 -p旧密码 password 新密码
例子：mysqladmin -uroot -p123456 password 123
方法3：用UPDATE直接编辑user表
mysql> use mysql;
mysql> update user set password=password('123') where user='root' and host='localhost';
mysql> flush privileges;

 1 [mysql]
 2
 3 #设置mysql客户端默认字符集
 4 
 5 default-character-set=utf8
 6 
 7 [mysqld]
 8 
 9 #设置mysql端口
10 
11 port=3306
12 
13 #设置mysql安装目录
14 
15 basedir=E:\Mysql56\mysql-5.6.47-winx64\mysql-5.6.47-winx64
16 
17 #设置mysql存放data的目录
18 
19 datadir=E:\Mysql56\mysql-5.6.47-winx64\mysql-5.6.47-winx64\data
20 
21 #允许最大的连接数
22 
23 max_connections=200
24 
25 #服务端使用字符集默认为8比特编码的latin1字符
26 
27 character-set-server=utf8
28 
29 #创建新表时默认的存储引擎
30 
31 default-storage-engine=INNODB
32 
33 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

 1 [mysqld]
 2 port=3307
 3 basedir=E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64
 4 datadir=E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\data
 5 max_connections=200
 6 max_connect_errors=10
 7 character-set-server=utf8
 8 default-storage-engine=INNODB
 9 default_authentication_plugin=mysql_native_password
10 # 设置3307端口，为了与旧版本的区分不冲突
11 # 设置mysql的安装目录
12 # 切记此处一定要用双斜杠\\，单斜杠我这里会出错，不过看别人的教程，有的是单斜杠。自己尝试吧
13 # 设置mysql数据库的数据的存放目录
14 # 允许最大连接数
15 # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
16 # 服务端使用的字符集默认为UTF8
17 # 创建新表时将使用的默认存储引擎
18 # 但因为当前有很多数据库工具和链接包都不支持“caching_sha2_password”，为了方便，我暂时改回了“mysql_native_password”认证插件。<br>#默认使用“mysql_native_password”插件认证
19 [mysql]
20 # 设置mysql客户端默认字符集
21 default-character-set=utf8
22 [client]
23 # 设置mysql客户端连接服务端时默认使用的端口
24 port=3307
25 default-character-set=utf8

E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\bin>mysqld --initialize --console
2020-02-02T06:04:37.062657Z 0 [System] [MY-013169] [Server] E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 9616
2020-02-02T06:04:37.065698Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2020-02-02T06:04:37.065724Z 0 [ERROR] [MY-013236] [Server] The designated data directory E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\data\ is unusable. You can remove all files that the server added to it.
2020-02-02T06:04:37.089282Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-02-02T06:04:37.091878Z 0 [System] [MY-010910] [Server] E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\bin>mysqld --initialize --console
2020-02-02T06:07:06.828384Z 0 [System] [MY-013169] [Server] E:\Mysql8\mysql-8.0.19-winx64\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 4372
2020-02-02T06:07:10.079556Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Zkhir&Cd3Nug