ubuntu重置mysql密码

修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]段下加入一行 skip-grant-tables

重启mysql服务
service mysql restart

用空密码进入mysql，切换到mysql数据库
mysql
use 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;

把skip-grant-tables去掉，再次执行步骤2

用新密码重新登录即可