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