mysql创建用户权限

mysql 权限如下：

root@localhost : (none) 17:34:45> create user diamonduser identified by 'diamonduser';
Query OK, 0 rows affected (0.01 sec)

root@localhost : (none) 17:36:00> grant all on diamond.* to diamonduser@'localhost';
Query OK, 0 rows affected (0.01 sec)

root@localhost : (none) 17:37:04> grant all on diamond.* to diamonduser@'%';
Query OK, 0 rows affected (0.01 sec)

flush privileges

 

注意: localhost没有密码