Admin: /* HOW */

2009-10-11T10:18:32Z

HOW

← Older revision		Revision as of 13:18, 11 October 2009
Line 20:		Line 20:

	5. Do this:		5. Do this:
			<source lang="mysql">
	mysql> UPDATE mysql.user SET Password=PASSWORD('l33tP4ssw0rd') WHERE User='root';		mysql> UPDATE mysql.user SET Password=PASSWORD('l33tP4ssw0rd') WHERE User='root';
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
			</source>

	5. \q		5. \q

Admin: 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...

2009-10-11T10:18:08Z

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...

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/pid.file`

2. Start again with --skip-grant-tables

3. Start mysqld
<source lang="bash">
sudo -u mysql mysqld --skip-grant-tables &
</source>

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.

[[Category: MySQL]]

Resetting MySQL root password - Revision history

Admin: /* HOW */

Admin: 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...