Delete user from MySQL user problem

[jamesang5]

hi, i have a problem here, i after i use the command below :-

"DELETE FROM mysql.user WHERE user ='" & User_ID & "'"


The user in the [user table] is deleted, but when i log in to mysql again, that user name and password still can log in. can i know why this kind of problem can happen.


another problem again, when i update the password in user table, after i log in to mysql again, i found that the new password and old password also can access. i really don't know why this kind of this is going to happen.

i hope i can get a solution as soon as possible, thank you.

Regards, James

[JCScoobyRS]

Make sure you do a commit afterwards and that your user that you are connected with has permissions to delete. Laters, Jeremy