mysql常用语句

1. 创建数据库

create database xxx

2. 配置用户并配置权限

grant all on db.* to 'user'@'%' identified by 'passwd'

3. 修改密码校验规则

set global validate_password_policy=0;
set global validate_password_length=1;

4. 修改用户可以远程访问

grant all privileges on `xx_%`.* to 'root'@'%' identified by '123456' with grant option;

5. 修改数据库表大小写不敏感
   修改my.cnf在mysqld下添加lower_case_table_names = 1