mysql 启动失败 (2003-can‘t connect to mysql server on ‘localhost‘(10061))

1、管理员身份运行cmd

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysqld -install
Service successfully installed.  

证明mysql安装成功

2、排查 net start mysql

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysql -u root -p
Enter password: ******
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>net start mysql
服务名无效。

请键入 NET HELPMSG 2185 以获得更多的帮助。

mysql没有加入window服务中

3、先执行mysqld.exe –install，在执行net start mysql

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysqld.exe -install
The service already exists!
The current server installed: "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" MySQL

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

4、输入mysql -u root -p

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysql -u root -p
Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

5、Navicat连接成功