忘记密码 在文件【my.ini】的【mysqlId】字段最下面加入【skip-grant-tables】，重启mysql服务
mysql> use mysql; Database changed mysql> 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>
