How to reset the MySQL password

2. How to reset the MySQL password
6. If the password is known, it is modified by the following way;
10. [email protected]:~$ mysql --user=root--pass mysql
12. Enter Password:
16. MySQL> Update user set password=Password (' New-password-here ') WHERE user=' root ';
18. Query OK, 2 rows affected (0.04 sec)
20. Rows matched:2 Changed:2 warnings:0
24. MySQL> Flush privileges;
26. Query OK, 0 rows affected (0.02 sec)
30. MySQL> Exit
32. Bye
36. If you forget your password, stop MySQL first and then add the parameter skip-grant-tables to restart MySQL server
40. [Email protected]:~#/etc/init.d/mysql Stop
44. Now your should start up the database in the background, via the Mysqld_safe command:
48. [Email protected]:~#/usr/bin/mysqld_safe--skip-grant-tables &
50. [1] 4271
52. Starting mysqld daemon with databases From/var/lib/mysql
54. MYSQLD_SAFE[6763]: Started
58. Then log in to MySQL, change the password
62. [email protected]:~$ mysql --user=root mysql
64. Enter Password:
68. MySQL> Update user set password=Password (' New-password-here ') WHERE user=' root ';
70. Query OK, 2 rows affected (0.04 sec)
72. Rows matched:2 Changed:2 warnings:0
76. MySQL> Flush privileges;
78. Query OK, 0 rows affected (0.02 sec)
82. MySQL> Exit
84. Bye
88. Finally, restart MySQL server.
92. [Email protected]:~#/etc/init.d/mysql Start
94. Starting MySQL database Server:mysqld.
96. Checking for corrupt, not cleanly closed and upgrade needing tables.
100. Login with the new password to verify
104. [email protected]:~# mysql --user=root --pass=new-password-here
106. Welcome to the MySQL Monitor. Commands End With; or \g.
108. Your MySQL Connection ID is 5 to server Version:5.0.24a-debian_4-log
112. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the buffer.
116. MySQL> Exit
118. Bye

How to reset the MySQL password