修改 root 的密码
alter user 'root'@'localhost' identified by '111111';
-- 解决 cache_sha2_password 问题
alter user 'test'@'%' identified WITH mysql_native_password by '111111';
flush privileges;
创建用户并设置权限
CREATE USER 'test'@'%' IDENTIFIED BY '111111';
grant all privileges on *.* to 'test'@'%';
flush privileges;
MySQL大小写不敏感
必须在初始化数据库前配置my.cnf 文件
0 表示大小写敏感, 1 表示大小写不敏感
lower_case_table_names=1