Reset Password of a User in SQL via VB

[Anon]

Hi,
I would like to know how to reset an SQL server password for a user(via the administrator) without knowing his password.
yours truly hariharan

[Anon]

You can modify the user table of the mysql database directly to reset the password...

After the modification, you need to send the command "FLUSH PRIVILEGES" to reload the updated user table ... For more information check out http://www.mysql.com/doc/A/d/Adding_users.html

John
[ black dog, brown dog, you decide @ smashedbug.com ]