忘记密码 在文件【my.ini】的【mysqlId】字段最下面加入【skip-grant-tables】，重启mysql服务

mysql> use mysql;

Database changedmysql> select User from user; #此处为查询用户命令+-----------+| User |+-----------+| *** || mysql.sys || root |+-----------+3 rows in set (0.00 sec)

mysql> update user set password=password("") where user=""; #修改密码报错

ERROR 1054 (42S22): Unknown column 'password' in 'field list'mysql> update mysql.user set authentication_string=password('') where user=''; #修改密码成功Query OK, 1 row affected, 1 warning (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 1

mysql> flush privileges; #立即生效

Query OK, 0 rows affected (0.00 sec)

mysql> quit

Bye

n>mysql -u *** -p #以该用户登录成功.

Enter password: ****…………………………mysql>