同样是删用户,为啥还有差别?

在MySQL当中,对于删除用户的操作大家并不陌生,先来看看问题:

# 创建用户testuser01mysql> create user 'testuser01'@'%' identified by 'Test01.~!#';Query OK, 0 rows affected (0.01 sec)# 删除用户testuser01mysql> drop user 'testuser01'@'%';Query OK, 0 rows affected (0.01 sec)# 再次创建testuser01成功mysql> create user 'testuser01'@'%' identified by 'Test01.~!#';Query OK, 0 rows affected (0.01 sec)