设置表名大小写不敏感
1 停止MySQL
2 删除 MySQL的数据 /var/lib/mysql (如果之前启动过了)
3 修改该 lower_case_table_names = 1
4 启动 mysql
centos命令
启动mysql服务
systemctl start mysqld.service
停止mysql服务
systemctl stop mysqld.service
重启mysql服务
systemctl restart mysqld.service
查看mysql服务当前状态
systemctl status mysqld.service
设置mysql服务开机自启动
systemctl enable mysqld.service
停止mysql服务开机自启动
systemctl disable mysqld.service
mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Lzy@123!!!';
创建用户
create user 'lzy'@'%' identified by 'Lzy@123~~~';
解决：Authentication plugin 'caching_sha2_password'
ALTER USER 'lzy'@'%' IDENTIFIED WITH mysql_native_password BY 'Lzy@123~~~';
flush privileges;
允许远程访问:
GRANT ALL PRIVILEGES ON *.* TO 'lzy'@'%'WITH GRANT OPTION;
// %:表示从任何主机连接到mysql服务器
FLUSH PRIVILEGES;
