mysql忘记root密码

mysql忘记root密码

 

万能的百度

https://jingyan.baidu.com/article/454316ab4e9e65f7a7c03ad1.html

 

1     mysqld --skip-grant-tables

2     mysql

3     use mysql

4     update user set password=password('123456') where user='root' and host='localhost'