ubuntu 16.04 下的 Mysql 密码重置

1.编辑文件 /etc/mysql/mysql.conf.d/mysqld.cnf 在[mysqld]段下加入一行“skip-grant-tables”

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-grant-tables

2.重启 mysql

sudo service mysql restart

3.用空密码进入 mysql 管理命令行。

mysql

4.mysql 命令行操作

mysql> use mysql;
mysql> update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost';
update user set plugin="mysql_native_password";
flush privileges;
quit;

5.回到/etc/mysql/mysql.conf.d/mysqld.cnf, 删除或者注释掉"skip-grant-tables";
6.重启 mysql

sudo service mysql restart

7.使用新密码登录,密码修改成功

mysql -u root -p new_pass