MySQL密码忘了怎么办？MySQL重置root密码方法

一、单实例Mysql密码丢失解决办法

# ps -ef|grep 3306         # 查看3306实例的PID# kill PID                 # kill PID# mysqld_safe --skip-grant-table &# > update mysql.user set password=PASSWORD("123456") where user='root' and host='localhost';# > flush privileges;# ps -ef |grep 3306# kill PID                    # mysqld_safe还在后台运行，需kill重启mysql服务# /etc/init.d/mysqld start# mysql -uroot -p123456Welcome to the MySQL monitor.  Commands end with ; or \g. ... ...mysql>

二、多实例Mysql密码丢失解决办法

# ps -ef |grep 3308     # kill PID              # mysqld_safe --defaults-file=/data/3308/my.cnf --skip-grant-table 2>&1 >/dev/null &# mysql -S /data/3308/mysql.sock > update mysql.user set password=PASSWORD("0818") where user='root' and host='localhost';> flush privileges;> quit# ps -ef |grep 3308# kill pid# /data/3308/mysql start# mysql -uroot -p0818 -S /data/3308/mysql.sock Welcome to the MySQL monitor.  Commands end with ; or \g.......mysql>