1.停止mysql sudo systemctl stop mysqld
2.做好备份删除 sudo rm -rf /var/lib/mysql(一定要做好备份)
3.初始化数据库 sudo /usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1(0区分 1不区分)
4.启动mysql sudo systemctl start mysqld
5.查看初始化密码 cat /var/log/mysqld.log | grep password
6.查看大小 SHOW VARIABLES LIKE 'lower_case_table_names';