更改超管密码
alter user 'root'@'localhost' identified by '123456';
创建用户和密码
创建用户
create user 'fox'@'%' identified by '999999';
用户授权(全部权限)
grant all privileges on *.* to 'fox'@'%';
# 刷新权限
flush privileges;
创建 库
CREATE DATABASE IF NOT EXISTS fox \
CHARACTER SET utf8mb4 \
COLLATE utf8mb4_general_ci ;
utf8mb4_bin: 区分大小写的,也区分e和é类字符的
utf8mb4_genera_ci: 不区分大小写的,也不区分e和é类字符