1、新建数据库ceshidb
create database ceshidb;
2、新建本地登录的用户ceshi01密码为ceshipw
CREATE USER 'ceshi01'@'localhost' IDENTIFIED BY 'ceshipw';
3、新建127.0.0.1登录的用户ceshi01密码为ceshipw
CREATE USER 'ceshi01'@'127.0.0.1' IDENDIFIED BY 'ceshipw';
4、新建任意位置登录的用户ceshi01密码为ceshipw
CREATE USER 'ceshi01'@'%' IDENTIFIED BY 'ceshipw';
5、授权ceshi01用户ceshidb数据库权限，可以任意位置
GRANT ALL ON ceshidb.* TO 'ceshi01'@'%';
6、刷新权限
flush privileges;