1. 创建用户
CREATE USER 'tianlihu'@'%' IDENTIFIED BY 'tianlihu';
2. 创建数据库
CREATE DATABASE test CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
3. 赋权限给用户
GRANT ALL ON test.* TO 'tianlihu'@'%' ;
1. 创建用户
CREATE USER 'tianlihu'@'%' IDENTIFIED BY 'tianlihu';
2. 创建数据库
CREATE DATABASE test CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
3. 赋权限给用户
GRANT ALL ON test.* TO 'tianlihu'@'%' ;