1、首先启动mysqld,无授权验证模式,为了安全,将监听地址bind在localhost
2、运行mysql
cmd>mysqld --skip-grant-tables --bind-address=localhost
2、运行mysql
cmd>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.90-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
mysql> select host, user, password from user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *41DDB5DFD213B288EE050BD64DC6AA36815A3486 |
+-----------+------+-------------------------------------------+
1 row in set (0.00 sec)
mysql> UPDATE user SET password=password('888') WHERE user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.13 sec)
mysql> quit;
Bye
cmd>