Mon Dec 23 10:37:41 EST 2013
Mysql root password
I have a debian mysq install but forgot the root password.
- how to fix, see .
- why is it important to have separate root pw auth?
In  it is mentioned this is insecure. Why?
So I don't understand why it is insecure, but let's just go with the
flow here and follow directions. As a matter of convention, just
create a root-readable/executable file /root/mysql containing the
In  it says to use these commands in the init file specified as
mysqld_safe --init-file=.... This did not work for me.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
Using this instead: