Shulou(Shulou.com)06/01 Report--

The newly installed MySQL 5.7, when login prompt password error, installation time did not change the password, and later change the password through password-free login, enter update mysql.user set password=password ('root ') where user='root'prompt ERROR 1054 (42S22): Unknown column 'password' in 'field list', the original mysql database has no password field, password field changed to authentication_string

So change the statement to update mysql.user set authentication_string=password ('root ') where user ='root' ;

My system version is as follows:

The complete way to change MySQL passwords is as follows:

The requested URL/etc/was not found on this server.

/etc/init.d/mysqld restart MySQL

3. Enter mysql in the terminal to log in to MySQL database directly, and then use mysql.

4、update mysql.user set authentication_string=password('root') where user='root' ;

mysql5.7 Changing passwords should be done with the command ALTER USER 'root'@'localhost'IDENTIFIED BY '******' where the naming convention for passwords has changed.

MySQL passwords must contain at least one upper-case letter, one lower-case letter, one special symbol, one number,

Passwords must be at least 8 characters long

5. Edit my.cnf file to delete the skip-grant-tables line, and then restart MySQL,/etc/init.d/mysqld restart, otherwise MySQL can still login without password

6、mysql -u root -p

Then enter your password to log in to MySQL database

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.