Reset mysql root or user password

Reset the mysql root user password
Stop the mysql server:
sudo service mysql stop

Start mysql in save mode and make it skip evaluating the grant tables (thats where password hashes are stored):
/usr/bin/mysqld_safe –skip-grant-tables &

Now you can login as root without a password, using the database mysql:
mysql -u root mysql

I prefer to generate passwords via the […]

By |November 8th, 2012|MySQL|6 Comments