MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’

This intention is to change a user’s password. The command found on the Internet is as follows

1

MySQL & gt; update user set password = password ("new password") where user = "user name";

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: