MYSQL报错ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
mysql 报错 Error number HY000 be HASH password
2023-09-11 14:19:17 时间
问题描述
修改MySQL密码提示：ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
问题原因
输入的密码是明文，要求输入十六进制数字。
解决方案
使用mysql命令行：select password('密码'); ，查询密码对应的十六进制码，然后使用十六进制码进行修改，问题即可解决。
select password('密码');
相关文章
- 【C/C++学院】（23）Mysql数据库编程--C语言编程实现mysql客户端
- MySQL 从 5.5 升级到 5.6，启动时报错 [ERROR] Plugin 'InnoDB' init function returned error
- 【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- Linux - mysql 异常： ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- MYSQL错误解决：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- mysql启动时报错：Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- MYSQL随机抽取查询 MySQL Order By Rand()效率问题
- ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错：2006 - MySQL server has gone away
- 【MySQL笔记】mysql来源安装/配置步骤和支持中国gbk/gb2312编码配置
- mysql_10 _ MySQL为什么有时候会选错索引？
- MySQL缺失mysql_config文件
- win7 64下安装mysql-python报错的解决办法
- MySQL 报错：ERROR 1137 (HY000): Can't reopen table: 'tempId'
- Linux Centos8 Mysql启动（Active: failed (Result: exit-code)）及登录报错（ERROR 1045 (28000): Access denied ）
- Mysql安装多台mysql
- 华为交换机SSH报错Socket error Event: 32 Error: 10053. Connection closing...Socket close.
- Repo报错：GnuTLS recv error (-9): Error decoding the received TLS packet.