mysql命令行添加用户并赋予权限

mysql> create user 'admin'@'%' identified by '123456';
Query OK, 0 rows affected
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected

mysql> grant all privileges on *.* to 'admin'@'%'identified by '123456';
Query OK, 0 rows affected

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected

mysql>