What to do if you forget your mysql password

[root@localhost ~]# mysql -uroot -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@localhost ~]# mysql -uroot -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@localhost ~]# service mysqld stop
Stopping mysqld: [ OK ]

skip-grant-tables //Skip authorization and enter the database directly

[root@localhost ~]# service mysqld start
[root@localhost ~]# mysql -uroot -p  
mysql>

mysql> use mysql //The password is stored in MySQL, you need to enter mysql> desc user; //View the fields in the user table. Passwords are generally stored in the password table. +------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |

mysql> update user set password=password('passw0rd') where user="root"; //Set the password to passw0rd
mysql> flush privileges; // refresh

[root@localhost ~]# mysql -uroot -ppassw0rd
mysql>