MySQL创建用户并赋权限

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'@'%' ;

 

CREATE USER 'sonar' IDENTIFIED BY 'sonar';
GRANT ALL PRIVILEGES ON *.* TO 'sonar'@'%' IDENTIFIED BY 'sonar' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'sonar'@'localhost' IDENTIFIED BY 'sonar' WITH GRANT OPTION;
FLUSH PRIVILEGES;