Reset MySQL root password

Reset MySQL root password Organic Design procedure

To reset the root password of a MySQL server, first go to a root shell and stop MySQL:

/etc/init.d/mysql stop

Next, run MySQL in safe mode in the background:

/usr/local/mysql/bin/safe_mysqld --user=mysql --skip-grant-tables --skip-networking &

Reset the MySQL root password:

/usr/local/mysql/bin/mysqladmin -u root flush-privileges password "******"

And restart the MySQL server again:

/etc/init.d/mysql restart