mysql密码修改问题
Windows修改MySQL 5.7密码遇到的问题
1.不知道密码登录不进去
修改配置文件,Windows下是 my.ini,在mysqld下增加一行skip-grant-tables
,然后重新启动MySQL服务,再次无密码登录即可;
2.修改密码:5.7就没有password字段了
mysql> update user set password = password("******") where user = "root";
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql> update mysql.user set authentication_string = password("******") where user = "root";
Query OK, 1 row affected, 1 warning (0.07 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> quit;
Bye
3.修改完密码得把刚才第一步添加的那行去掉
4.mysql -uroot -p 输入密码进入 完事