Bug #16216 drop user
Submitted: 5 Jan 2006 8:13 Modified: 5 Jan 2006 12:42
Reporter: mkysoft sofware Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.4 OS:Windows (Windows XP with all updates)
Assigned to: MySQL Verification Team CPU Architecture:Any

[5 Jan 2006 8:13] mkysoft sofware
drop user function doesn't running. it doesn't delete user names from mysql.user table.

How to repeat:
[5 Jan 2006 12:42] MySQL Verification Team
I was unable to repeat the behavior reported:

C:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.4-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select user from mysql.user where user="miguel";
| user   |
| miguel |
1 row in set (0.00 sec)

mysql> drop user miguel@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> select user from mysql.user where user="miguel";
Empty set (0.00 sec)