Reference: https://developer.aliyun.com/article/676469
Last instruction to change password:
mysql -uroot -p
user mysql
set password for 'root'@'%' = '123456';
Read More:
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL forgot the root password
- Root password of windows 10 WSL Ubuntu system
- MySQL 8 — error in setting simple password error 1819 (HY000): your password does not satisfy the current policy requirements
- Error 1064 in MySQL password change
- Setting the root password of windows 10 Ubuntu subsystem
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- MySQL modify character set
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- Error (1820) if the password is not changed in time after MySQL installation
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- Question: cannot create windows service for mysql.error : 0 (install MySQL)
- MySQL — initialize failed to generate temporary password in error log after initialization
- Error loading password’s fault file (MySQL for Excel)
- Error 1045 (28000) access denied for user ‘root’ @’localhost ‘appears in MySQL under Windows system
- NPM modify download dependency (modify global download and cache path)
- (Windows+xrdp+ubuntu16.04) Remote server error: “password failed error-problem connecting”