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

1, add a line to / etc/my.cnf

Skip-grant-tables

Save exit

2,service mysqld restart

3Perfect MySQL-uroot-p enter directly into mysql

4, enter after login

Use mysql

Select host, user, authentication_string, plugin from user

Update user set authentication_string='' where user='root'

Quit

5,vi / etc/my.cnf

Comment out or delete skip-grant-tables

Save exit

6,service msqld restart

7Jing MySQL-u root-p enter directly into mysql

8. Set a new password after login

nine,

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'

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.