mysqlパスワードを忘れた場合の解決策を共有する

[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  //跳过授权直接进入数据库

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