Reset mysql root password

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 Over 11 years ago