Login server as root and stop/kill mysql processes
Start mysql server with skip-grant-tables
mysqld_safe --skip-grant-tables mysql use mysql; update user set Password=PASSWORD('new-password') where user='root'; flush privileges;
Done!
Now kill mysql processes and restart your mysql server
Similar Posts:
- How to reset MySQL root password
- How to create a MySQL database, username, password and privileges from the mysql command line
- How to create database, database username and grant all rights on cPanel server via command line using UAPI
- How to reset WordPress password through MySQL command line
- ClientExec how to reset password via mysql command line