mysql> grant all privileges on test.* to 'ybb'@'%' identified by 'ybb';

Query OK, 0 rows affected (0.07 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> select host,user,password from mysql.user where user='ybb' and host='%';

+-----------+---------+-------------------------------------------+

| host      | user    | password                                  |

+-----------+---------+-------------------------------------------+

| %         | ybb      | *C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB |

+-----------+---------+-------------------------------------------+

1 rows in set (0.00 sec)

mysql> show grants for ybb;

+---------------------------------------------------------------------------------------------------+

| Grants for ybb@%                                                                                   |

+---------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'ybb'@'%' IDENTIFIED BY PASSWORD '*C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB' |

| GRANT ALL PRIVILEGES ON `test`.* TO 'ybb'@'%'                                                      |

+---------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> revoke insert on test.* from ybb@'%';

Query OK, 0 rows affected (0.00 sec)

mysql> show grants for ybb;

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for ybb@%                                                                                                                                                                                                    |

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'ybb'@'%' IDENTIFIED BY PASSWORD '*C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB'                                                                                                                  |

| GRANT SELECT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `test`.* TO 'ybb'@'%' |

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql>

 select,

 insert,

 update,

 delete,

 create,

 drop,

 references,

 index,

 alter,

 create temporary tables,

 lock tables,

 execute,

 create view,

 show view,

 create routine,

 alter routine,

 event,

 trigger