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

Environment centos7, mysql5.7

1. Suspension of service

Systemctl stop mysqld

2. Modify my.cnf

Vi / etc/my.cnf

# add a line under [mysqld]

Skip-grant-tables=1

Start

[root@linux~] # systemctl start mysqld

Third, change the password

[root@linux~] # mysql

Mysql > UPDATE mysql.user SET authentication_string=PASSWORD ('NEWPASSWORD'), plugin='mysql_native_password' WHERE User='root'

Mysql > exit

IV. Comment out the configuration

Vi / etc/my.cnf

# add a line under [mysqld]

# skip-grant-tables=1

Restart the database

Systemctl restart mysqld

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.