mysql 创建用户和分配权限

mysql -u root -p
输入密码
use mysql
create user 'test'@'%' identified by '111111';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY '111111' WITH GRANT OPTION;
FLUSH PRIVILEGES;