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

[nkad]

This is not the proper place to post this question...


You need to flush the grants table


here


http://www.mysql.com/doc/en/Privilege_changes.html


Read and learn, my son.