Stop MySQL server

service mysqld stop

Start in safe mode

mysqld_safe --skip-grant-tables &

Login mysql server

mysql

Reset your root password

UPDATE mysql.user SET Password=PASSWORD('strong-password-here') WHERE User='root';

FLUSH PRIVILEGES;
exit;

Shutdown your mysql server

mysqladmin -u root -p shutdown

Start your mysql server again

service mysqld start

Similar Posts:

• How to reset forgotten mysql root password
• How to create a MySQL database, username, password and privileges from the mysql command line
• Joomla reset password using mysql command line
• How to reset WordPress password through MySQL command line
• How to create database, database username and grant all rights on cPanel server via command line using UAPI