【mysql】ERROR 1054 (42S22): Unknown column '‘root‘' in 'where clause'
来源:互联网 发布:java线程优先级 编辑:程序博客网 时间:2024/06/06 03:57
今天在安装mysql的时候,前面的步骤都没有太大的问题,但是到了想要重置密码的时候出现了问题,ERROR 1054 (42S22): Unknown column '‘root‘' in 'where clause',不管如何用sql语句进行重置,它都会出现这样的提示语句,我用的语句如下:
update user set password=password(‘123456‘) where user=‘root‘;
update user set password=password("123456") where user="root";
然后就可以正常登陆
阅读全文
0 0
- 【mysql】ERROR 1054 (42S22): Unknown column '‘root‘' in 'where clause'
- MySQL数据库删除用户报错:ERROR 1054 (42S22): Unknown column 'User' in 'where clause'
- SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbl_contact' in 'where clause'.
- SQLSTATE[42S22]: Column not found: 1054 Unknown column 'staff_info.depart_id' in 'where clause'
- mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
- ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
- MySQL 5.7.16 修改密码 ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- 解决 ERROR 1054 (42S22): Unknown column ‘plugin’ in ‘mysql.user’ 的问题
- Column not found: 1054 Unknown column 'tl10709' in 'where clause'
- mysql 5.7 版本,密码无法登陆,更改密码时出现ERROR 1054 (42S22): Unknown column 'password' in 'fie
- mysql5.5升级为5.7遇到错误ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user'
- mysql5.5升级为5.7遇到错误ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user'
- Unknown column 'rownum' in 'where clause'解决方案
- Unknown column '安妮宝贝' in 'where clause'
- Unknown column '??????' in 'where clause'问题
- Unknown column 'xxx' in 'where clause'错误
- Unknown column 'ORGANIZATION_BANK' in 'where clause'
- 中文乱码 unknown column in 'where clause'
- linux-mail
- 疯狂队列问题
- lintcode-数飞机
- Monkey详解(入门篇)
- Linux必杀(十五):常见的压缩命令
- 【mysql】ERROR 1054 (42S22): Unknown column '‘root‘' in 'where clause'
- 中缀转后缀
- 算法导论学习笔记----动态规划
- fail-fast和fail-safe详解
- leetcode
- Tomcat源码分析(1)--启动流程图
- Raspberry Pi树莓派上的自定义动态开机画面
- 图片的本地压缩
- linux-http服务搭建