C:UsersAdministrator>cd C:Program FilesMySQLMySQL Server 5.5in
C:Program FilesMySQLMySQL Server 5.5in>net stop mysql
MySQL 服务正在停止.
MySQL 服务已成功停止。
C:Program
FilesMySQLMySQL Server 5.5in>mysqld --skip-grant-tables
你会看到窗口光标在下一行的第一个位置闪烁,这说明已经启动了,不需要管。
新建一个命令行窗口同样进入到e:mysql5.5in目录,启动mysql
C:Program FilesMySQLMySQL Server 5.5in>mysql
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD('oracle') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
看看那任务管理器中是否有mysqld.exe进程,如有,kill .
C:Program FilesMySQLMySQL Server 5.5in>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
C:Program FilesMySQLMySQL Server 5.5in>mysql -uroot -poracle