:: How to reset root password MySQL
+ stop mysqld
|
0 |
/etc/init.d/mysqld stop |
+ starting mysql with skip grant table on background
|
0 |
mysqld_safe --skip-grant-tables & |
+ login to mysql and reset password
|
0 1 2 3 |
mysql use mysql; update user set password=password('NEW_PASSWORD') where user='root'; quit; |
+ kill mysqld
|
0 |
pkill -9 mysqld |
+ starting mysql with new password
|
0 |
/etc/init.d/mysqld start |
