mysql创建用户

1、> mysql -uroot -p

2、mysql> CREATE USER 'user1'@'%' IDENTIFIED BY 'passwd';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'user1'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;