mysql命令：
mysqld --initialize-insecure
net stop mysql
net start mysql
update mysql.user set authentication_string=password(‘root‘) where user=‘root‘;
show variables like ‘%case%‘;
mysql命令：
mysqld --initialize-insecure
net stop mysql
net start mysql
update mysql.user set authentication_string=password(‘root‘) where user=‘root‘;
show variables like ‘%case%‘;
原文：https://www.cnblogs.com/luoyunyong/p/8143120.html