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

First contact with the database, after installing mysql5.7 in binary, it is found that the initial password can not be found in the log like yum. ~ so

First, shut down the startup database:

Add a new sentence to my.cnf: skip-grant-tables save exit restart mysql

Users can skip the password by logging in to mysql directly.

Change the password:

In the past, we modified it to use:

Update user set password=password ('mysqlpwd') where user='root'

However, the password field does not exist in version 5.7, so:

Update user set authentication_string=password ('mysqlpwd') where user='root'

Flush privileges

Finally, you can quit.

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.