Question

Resetting MySQL password.

Answer 1

Answer 2

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

C:\> "C:\Program Files\MySQL\MySQL Server\bin\mysqld-nt.exe"
         --defaults-file="C:\\Program Files\\MySQL\\MySQL Server \\my.ini"
         --init-file=C:\\mysql-init.txt

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

mysqld_safe --init-file=/home/me/mysql-init &