SQL root password reset

Resetting a myqsl root password

Here how to erase the root password (of course you need administrator privileges on the computer).

sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &

In the mysql console:

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

Stop mysql_safe server (with a kill) and

sudo /etc/init.d/mysql start

Now it's time to see in the logs who has changed this *$%#! password.

Design selector