mysql忘记root密码的处理

 

背景：两种重置MySQL的root密码的主流方式

干货：

1.Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

2.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

其实最靠谱的是第三种，pls try to find or pull out the PW from one place.

 

===========End，=============