安装mysql-6.0.5-alpha-win32,出现如下错误:Error Nr. 2003
Can't connect to MySQL server on 'localhost'(10061)If a personal firewall is running on your machine.please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server.After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.服务已经启动了,就是连不上,大侠们帮帮忙!
Can't connect to MySQL server on 'localhost'(10061)If a personal firewall is running on your machine.please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server.After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.服务已经启动了,就是连不上,大侠们帮帮忙!
telnet 127.0.0.1 3306 有问题-----“正在连接到127.0.0.1....不能打开到主机的连接,在端口3306:连接失败”,但是telnet localhost 3306 没出现该问题,也没报错,貌似正常的,my.ini中端口号是3306
ping localhost检查一下 %SystemRoot%\system32\drivers\etc\host文件中的 localhost 的定义。
ping localhost出现以下内容:
Pinging ...(省略下,呵呵) [::1] with 32 bytes of data:Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1msPing statistics for ::1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms %SystemRoot%\system32\drivers\etc\host文件中的 localhost 的定义为:127.0.0.1 localhost
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128Ping statistics for 127.0.0.1:
Packets: Sent = 2, Received = 2, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C[/code]如果你ping localhost的结果不是 127.0.0.1 则说有问题。
#
# this is a sample hosts file used by microsoft tcp/ip for windows.
#
# this file contains the mappings of ip addresses to host names. each
# entry should be kept on an individual line. the ip address should
# be placed in the first column followed by the corresponding host name.
# the ip address and the host name should be separated by at least one
# space.
#
# additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# for example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host127.0.0.1 localhost
cd C:\Program Files\MySQL\MySQL Server 5.1\bin
mysql ....
localhost 解析不对,要看你的DNS设置了。
D:\MySQL\MySQL Server 6.0\bin>mysql -u root -p -h 127.0.0.1
Enter password: ****
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (10061)
mysql -u root -p -h localhost
或者
mysql -u root -p -h xxx.xx.xx.xx (DNS解析出的IP)
mysql -u root -p -h localhost这个可以进去,
mysql -u root -p -h 127.0.0.1怎么就不行了?我用navicat连接mysql也连不上
navicat 为什么搞死也连不上 mysql?连别人的机器可以,很郁闷mysql -u root -p -h localhost进去时候密码怎么是空的?安装mysql时我设置了密码root的
期待更好的方法.