• Solution to error 1054 (42s22) when changing password in MySQL 5.7


    For the newly installed MySQL 5.7, you will be prompted with an incorrect password when you log in. You did not change your password during installation. Later, you changed your password by password free login and entered update mysql.user Error 1054 (42s22) is prompted when set password = password (‘root ‘) where user:’ root ‘: […]