数据库中user表中不需要的用户 drop，mysql

admin

mysql> select distinct concat('User: ''',user,'''@''',host,''';') as query from mysql.user;
+---------------------------------+
| query                           |
+---------------------------------+
: j& U; H# z. U  u+ o1 @; n! f( W! ]| User: 'expiretest'@'%';         |
| User: 'root'@'%';               |
| User: 'ysw'@'%';                |
* m! j' U/ y' a; X* J0 n| User: 'root'@'127.0.0.1';       |
' \5 d& u9 ^1 a4 ~" \+ S9 C! O% q| User: 'root'@'::1';             |
| User: ''@'centos6';             |
! v$ J, \8 H! y6 M+ y2 h| User: 'root'@'centos6';         |
! d: _" ^% @! s& [1 g| User: ''@'localhost';           |
| User: 'expiretest'@'localhost'; |
| User: 'root'@'localhost';       |
+---------------------------------+
7 ?; [7 b* X# ^' T6 }. |7 G+ ^10 rows in set (0.00 sec)

mysql> drop user 'root'@'z%';
Query OK, 0 rows affected (0.00 sec)
4 @& R: m8 G$ {1 s( n
$ l* v8 L* O" q4 g: T+ ^