1.启动mysql后正常登陆

2.查看sql中的root用户

selecthost,user,authentication_string,pluginfrommysql.user;+-----------+------------------+-------------------------------------------+-----------------------+|host|user|authentication_string|plugin|+-----------+------------------+-------------------------------------------+-----------------------+|localhost|mysql.infoschema|*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE|mysql_native_password||localhost|mysql.session|*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE|mysql_native_password||localhost|mysql.sys|*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE|mysql_native_password||localhost|root|*23AE809DDACAF96AF0FD78ED04B6A265E05AA257|mysql_native_password|+-----------+------------------+-------------------------------------------+-----------------------+4rowsinset(0.00sec)

3.重置密码

语法格式

selecthost,user,authentication_string,pluginfromuser;

plugin 密码加密方式

authentication_string 加密后的密码

注意 mysql8.0以后废弃了PASSWORD函数 添加密码的时候不需要使用函数

清空root密码

update user set authentication_string='你的密码' where mysql.user='root';

4.测试

mysql-uroot-p你的密码