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 ‘: unknown column’ password ‘in’ field ‘ It turns out that there is no password field in MySQL database. The password field is changed to authentication_ string
So the change statement is replaced by update mysql.user set authentication_ String = password (‘root ‘) where user:’ root ‘; that is
My system version is as follows:
The complete way to change MySQL password is as follows:
1、vim /etc/ my.cnf Add skip grant tables
2. Restart mysql, / etc / init.d/mysqld restart
3. The terminal can directly log into MySQL database by inputting mysql, and then use mysql
4、update mysql.user set authentication_string=password(‘root’) where user=’root’ ;
To change the password in mysql5.7, you should use the command alter user ‘root’ @’localhost’identified by ‘*’.
The password set by MySQL must contain at least one uppercase letter, one lowercase letter, one special symbol and one number,
Password length is at least 8 characters
5. Editor my.cnf Delete the line skip grant tables in the file, and then restart mysql, / etc / init.d/mysqld restart, otherwise MySQL can still log in without password
6、mysql -u root -p
Then enter the password to log in to MySQL database
The above is the whole content of this article, I hope to help you in your study, and I hope you can support developeppaer more.