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