xiaoysh8 · September 26, 2017 15:45
diff --git a/reset mysql root password b/reset mysql root password
 First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
 mysqld_safe --skip-grant-tables

 You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
 mysql --user=root mysql

 update user set Password=PASSWORD('new-password') where user='root';
 flush privileges;
 exit;
	First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
	mysqld_safe --skip-grant-tables

	You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
	mysql --user=root mysql

	update user set Password=PASSWORD('new-password') where user='root';
	flush privileges;
	exit;