Reset mysql root password

Posted . Visible to the public.

Start mysql in safe mode: sudo mysqld_safe --skip-grant-tables

Connect to mysql database with mysql mysql

Reset password with Update user Password = PASSWORD('root') where User = 'root' and HOST = 'loalhost';

basiszwo
Posted by basiszwo to NinjaConcept KB (2012-12-11 23:55)