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没有密码