Solution to forgetting the root password of MySQL 5.7 and 8.0 database

[root@mysql01 ~]# mysql --version #Determine the MySQL version mysql Ver 14.14 Distrib 5.7.28, for linux-glibc2.12 (x86_64) using EditLine wrapper
[root@mysql01 ~]# vim /etc/my.cnf #Edit the main configuration file [mysqld] #Write the following content under the mysqld line skip-grant-tables
      .................#Omit some content[root@mysql01 ~]# systemctl restart mysqld #Restart the MySQL service to make the configuration file effective[root@mysql01 ~]# mysql -uroot #Skip password verification and log in to the database directly#Change the root password to pwd@123 and refresh the permissionsmysql> use mysql;
mysql> update user set authentication_string = passwoord('pwd@123') where user = 'root';
mysql> flush privileges; #Refresh privilegesmysql> exit
#Configure password verification and log in with the new password [root@mysql01 ~]# vim /etc/my.cnf #Edit the main configuration file [mysqld] 
skip-grant-tables #Delete this line [root@mysql01 ~]# systemctl restart mysqld #Restart to make the changes take effect #You can successfully log in using the new password [root@mysql01 ~]# mysql -uroot -ppwd@123

[root@mysql01 ~]# mysql --version # View MySQL version mysql Ver 8.0.18 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
[root@mysql01 ~]# vim /etc/my.cnf #Edit the main configuration file [mysqld] #Write the following content under the mysqld line skip-grant-tables
      .................#Omit some content[root@mysql01 ~]# systemctl restart mysqld #Restart the MySQL service to make the configuration file effective[root@mysql01 ~]# mysql -uroot #Skip password verification and log in to the database directly#Set the root password to emptymysql> use mysql
mysql> update user set authentication_string='' where user = 'root';
mysql> flush privileges;
mysql> exit
# Enable password verification and re-login to the database [root@mysql01 ~]# vim /etc/my.cnf # Edit the main configuration file [mysqld] 
skip-grant-tables #Delete this line [root@mysql01 ~]# systemctl restart mysqld #Restart to make the changes take effect [root@mysql01 ~]# mysql -uroot #Log in to the database directly mysql> alter user root@localhost identified by 'pwd@111';
mysql> flush privileges;
mysql> exit
#Login test using the new password [root@mysql01 ~]# mysql -uroot -ppwd@111