猜想可能是服务未启动，启动MySQL服务
先执行mysqld --install ，再执行net start mysql

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld-nt --skip-grant-tables

111230 10:45:14 [ERROR] Can't find messagefile 'D:\Program Files\MySQL\MySQL Server 5.0\share\english\errmsg.sys'

111230 10:45:14 [ERROR] Aborting

解决方法：将MySQL Server\bin下的my.ini删除或修改(我将其改了个名字，后来MySQL数据库可用之后，我又将其还原了)，再执行：
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld-nt --skip-grant-tables

开启另一个cmd窗口，输入mysql

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql

修改密码
mysql> use mysql

mysql> update user set password=password("123456")
-> where user ="root";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings:

ITPub博客

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

最新文章