Problem: ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
Because the password you enter is clear text, it requires you to enter hexadecimal digits.
Solutions:
#Use select password('password'): to find its corresponding hexadecimal code.
# Use hexadecimal codes instead of plaintext passwords
Example:
Read More:
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- [Solved] ERROR: child process failed, exited with error number 14 (error number 1, error number 100)
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- How To Change ASM SYS PASSWORD
- [Solved] Access denied for user ‘root‘@‘localhost‘ (using password: YES)
- Docker mysql8 modify password
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- Doris reports an error: error 1064 (HY000) [How to Solve]