Resetting MySQL root password: Difference between revisions
From D3xt3r01.tk
Jump to navigationJump to search
m New page: ==WHY== Because you forgot or misstyped your password too many times. ==HOW== 1. Kill the mysql /etc/init.d/mysqld stop or Locate your mysql .pid file and do kill -9 `cat /path/to/p... |
(No difference)
|
Revision as of 12:18, 11 October 2009
WHY
Because you forgot or misstyped your password too many times.
HOW
1. Kill the mysql
/etc/init.d/mysqld stop
or
Locate your mysql .pid file and do kill -9 `cat /path/to/pid.file`
2. Start again with --skip-grant-tables
3. Start mysqld
sudo -u mysql mysqld --skip-grant-tables &4. Run mysql
5. Do this: mysql> UPDATE mysql.user SET Password=PASSWORD('l33tP4ssw0rd') WHERE User='root'; mysql> FLUSH PRIVILEGES;
5. \q
6. Kill the mysqld and start it from the init script.
