如果你不在意数据的话直接删除数据(删数据库前请备份)
1 停止MySQL
2 删除 MySQL的数据 /var/lib/mysql
3 修改该 lower_case_table_names = 1
4 启动 mysql
4 搞定
解决Navicat连接MySQL出现1251-Client does not support authentication protocol requested by server;
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
mysql> flush privileges;