1. Environment
Reinstalled the environment on the new server, which was 5.6, and upgraded to version 5.7.
2. Problems
A new installation of MySQL 5.7 prompted a password error when logging in. I didn't change the password when I installed it, but later changed it by logging in password-free.
Enter.
update mysql.user set password=password('root') where user='root'
Error message: ERROR 1054 (42S22): Unknown column 'password' in 'field list'
3. Solutions
There is no password field in MySQL 5.7 + database. The password field is changed to authentication_ string.
#Just change the change statement to the following
update mysql.user set authentication_ string=password(‘root’) where user=’root’ ;
#Refresh permissions
flush privileges;
Similar Posts:
- [Solved] Error 1054 (42s22) unknown column ‘password’ in ‘field list’ when updating the password of mysql5.7 or above
- Solve the problem of unknown column ‘password’ in ‘field list’ in MySQL
- MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
- [Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded
- [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- mysql 1142 – SELECT command denied to user ‘root_ssm’@’localhost’ for table …
- [Solved] MYSQL ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mysql’
- MYSQL 8.0 Login Error: caching_sha2_password [How to Solve]
- Error in connecting to MySQL via Navicat on MAC