Error 1054 (42s22) unknown column 'password' in 'field list'

The reason for the error is that there is no password field in MySQL database of version 5.7, and the password field is changed to authentication_ string

Read More:

• MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
• MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
• Unknown column ‘Password‘ in ‘field list‘
• MySQL unknown column ‘in’ field list ‘solution
• How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
• Cause: java.sql.BatchUpdateException: Unknown column ‘xxx‘ in ‘field list‘
• MySQL error: column ‘ID’ in field list is ambiguous
• Mysql reports an error Operand should contain 1 column(s)
• MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
• MySQL error operation should contain 1 column (s)
• Error 1064 in MySQL password change
• Error (1820) if the password is not changed in time after MySQL installation
• MySQL 8 — error in setting simple password error 1819 (HY000): your password does not satisfy the current policy requirements
• MySQL — initialize failed to generate temporary password in error log after initialization
• MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
• MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
• MySQL forgot the root password
• MySQL advanced — Explanation of ref field in explain information
• Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
• Solution of duplicate entry ‘value’ for key ‘field name’ in MySQL