Linux下忘记mysql密码重置方法

kill掉所有mysql进程、修改/etc/my.cnf里面配置

 killall -TERM mysqld

  ps aux |grep mysqld

 vim /etc/my.cnf

在[mysqld]下添加skip-grant-tables，然后保存并退出

[mysqld]
skip-grant-tables
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8
innodb_file_per_table=true
log-bin=mysql-bin
server-id=222

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

  service mysqld restart

  mysql

  mysql> UPDATE mysql.user SET Password=PASSWORD ('123456') where USER='root';

  把/etc/my.cnf中的skip-grant-tables注释掉，然后重启mysql