[<<][sql][>>][..]
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
password.
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';
FLUSH PRIVILEGES;
Using this instead:
mysqld --skip-grant-tables
[1] http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
[Reply][About]
[<<][sql][>>][..]