查看“︁MySQL:忘记root密码”︁的源代码

首先停止mysql
<source lang="bash">
service mysql stop
</source>
然后以安全模式启动mysql在后台运行：
<source lang="bash">
mysqld_safe --skip-grant-tables &
</source>
然后就可以以root登录到mysql服务器上
<source lang="bash">
mysql -u root
use mysql
</source>
修改MySQL的root密码：
<source lang="sql">
update user set password=PASSWORD('123456') where User='root';

#MySQL 5.7
update user set authentication_string=password('123456') where user='root';
flush privileges;
</source>

[[Category:Database]]