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 [1].

- why is it important to have separate root pw auth?
In [1] 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 [1] 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:
mysqld --skip-grant-tables

[1] http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html