1. Error information
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement2. Cause of error
This error means that the original password needs to be changed to execute a MySQL statement
3. Solutions
Log in to MySQL
mysql -u root -pChange Password
mysql> SET PASSWORD = PASSWORD('123456'); 4. Error report
ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsIt means that the password you set is not complicated enough. It’s better to use numbers + letters + special characters
Read More:
- 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‘
- MySQL Change password failure prompt: ERROR 1064(42000):You have an error in your SQL syntax: check the corresponds to your M
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- MYSQL Use cmd to change root password error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- Docker mysql8 modify password
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- [Solved] FATAL ERROR: please install the following Perl modules before executing /application/mysql/scripts/mysql_install_db: Data::Dumper