The commands below will help you reset any mysql user password.

use mysql;


update user set password=PASSWORD('thenewpass') where User='theusername';


flush privileges;

1. The first line says to use the "mysql" database which contains all the user info.
2. the second update line sets the new password "thenewpass" for the user "theusername".
3. the third line flushes privileges this is necessary otherwise the new password will not work or actually be applied.

mysql, reset, passwords, commandsthe, commands, user, password, update, thenewpass, theusername, flush, privileges, quot, database, contains, info, flushes, applied,

Latest Articles