mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
来源:互联网 发布:js改变color rgb 编辑:程序博客网 时间:2024/05/24 04:27
mysql 忘记root密码后修改密码,发现update无法对password进行操作,并报出:ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
大神答案:update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost'; 即用authentication_string替换了password。
0 0
- mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
- MySQL5.7忘记密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL 5.7.16 修改密码 ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7.13更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- Windows下MySql5.7.17更改密码时出错“ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’"
- wamp修改数据库默认密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- 转载: MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'field list' 作者是剑侠365
- mysql 5.7 版本,密码无法登陆,更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'fie
- MySQL5.7更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'fie
- 【mysql】ERROR 1054 (42S22): Unknown column '‘root‘' in 'where clause'
- 307. Range Sum Query - Mutable
- 南阳理工学院ACM语言入门题目39水仙花数的思考与代码
- phpstorm常用快捷键图
- apache-tomcat-9安装
- 日历问题
- mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
- c语言:奇偶个数
- 进程间通信详解 - 剪贴板实现
- [解题报告]376. Wiggle Subsequence
- 字符串匹配问题
- uber使用的一些体验
- [LightOJ 1342] Aladdin and the Magical Sticks (期望的线性性质+几何分布+邮票收集问题)
- 网络工程1.7——七层模型之二数据链路层
- 题目1015:还是A+B