1. Modify the mysql startup Settings
# vim/etc/my CNF
Under the [mysqld]
Add: skip - grant - tables
2 to restart the mysql program
Systemctl restart mysqld
3 password-less logins
Mysql - uroot
4 change their passwords
Mysql> UPDATE the mysql. User SET
QianFeng authentication_string=password (' @ '123456789) where the user=' root 'and
The host='localhost';
5 refresh mysql
Mysql> FLUSH PRIVILEGES;