Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>C:\mysql\bin\mysqld --install mysql
Service successfully installed.C:\Documents and Settings\Administrator>net start mysql
mysql 服务正在启动 ....
mysql 服务无法启动。系统出错。发生系统错误 1067。
求助!!!!!!!!!!
(C) 版权所有 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>C:\mysql\bin\mysqld --install mysql
Service successfully installed.C:\Documents and Settings\Administrator>net start mysql
mysql 服务正在启动 ....
mysql 服务无法启动。系统出错。发生系统错误 1067。
求助!!!!!!!!!!
然后重启服务试试
错误日志100702 16:19:00 [Note] Plugin 'FEDERATED' is disabled.
100702 16:19:03 InnoDB: Started; log sequence number 0 44233
100702 16:19:03 [ERROR] Aborting100702 16:19:04 InnoDB: Starting shutdown...
100702 16:19:09 InnoDB: Shutdown completed; log sequence number 0 44233
100702 16:19:09 [Note] mysql: Shutdown complete
极有可能是防火墙的原因造成的。把mysqld进程及其端口号3306从你的防火墙里除去吧
是这个C:\mysql\bin\mysqld mysql
~~~~(>_<)~~~~
[收集]mysql 无法联接故障现象及原因
C:\Documents and Settings\Administrator>PING 61.129.152Pinging 61.129.0.152 with 32 bytes of data:Request timed out.
Request timed out.
Request timed out.
Request timed out.Ping statistics for 61.129.0.152:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),C:\Documents and Settings\Administrator>TELNET 61.129.49.152 3391
正在连接到61.129.49.152...不能打开到主机的连接, 在端口 3391.
由于系统缓冲区空间不足或队列已满,不能执行套接字上的操作。
我以前本地也装好过了,mysql安装不用连网的吧。
Request timed out.
Request timed out.
Request timed out.Ping statistics for 61.129.0.152:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),C:\Documents and Settings\Administrator>TELNET 61.129.49.152 3391
|||
我弄错了C:\Documents and Settings\Administrator>ping 61.129.49.152Pinging 61.129.49.152 with 32 bytes of data:Reply from 61.129.49.152: bytes=32 time<1ms TTL=128
Reply from 61.129.49.152: bytes=32 time<1ms TTL=128
Reply from 61.129.49.152: bytes=32 time<1ms TTL=128
Reply from 61.129.49.152: bytes=32 time<1ms TTL=128Ping statistics for 61.129.49.152:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0msC:\Documents and Settings\Administrator>TELNET 61.129.49.152 3391
正在连接到61.129.49.152...不能打开到主机的连接, 在端口 3391.
由于系统缓冲区空间不足或队列已满,不能执行套接字上的操作。
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENINGC:\>[/code]
我的安装步骤:1.下载mysql-noninstall-5.1.48-win32压缩包2.解压到C盘根目录下,并重命名为mysql3.修改mysql文件夹中的my-smail.ini名字为my.ini(my-huge.ini也尝试过),在my.ini中添加basedir=C:\mysql datadir=C:\mysql\data,然后将my.ini复制到windows中去。4.开始->运行->cmd->C:\Documents and Settings\Administrator>C:\mysql\bin\mysqld --install mysql
Service successfully installed.C:\Documents and Settings\Administrator>net start mysql
mysql 服务正在启动 ....
mysql 服务无法启动。系统出错。发生系统错误 1067。
我电脑上的3391端口状态是 establish
任务管理器里面是没有mysqld的,3391端口是没有其他的程序在用的。
我把端口改成3306,并开启skip-networking,然后netstat -an 出现的列表中没有3306这个端口。。
但是启动mysql后任务管理栏中还是没有mysqld.exe项
而且执行mysql -u root -p是出现ERROR 2004 (HY000): Can't create TCP/IP socket (10055)!!!!!!!!!!!!
你不防在c:\windows\my.ini里头
[mysqld]下添加一句:
bind-address=61.129.49.152
port=3306
并把skip-networking注释掉。
再启动。
如果还有问题,把机器所有的防火墙全部禁用,再启,先让它跑起来再说。
我还是不行,出现了ERROR 2004 (HY000): Can't create TCP/IP socket (10055)错误
唉!大哥,您再帮忙看看吧!要不远程控制也行,我实在是快疯了。
C:\mysql\bin>mysqld --console
出现错误日志
C:\Documents and Settings\Administrator>C:\mysql\bin\mysqld --console
100703 17:51:35 [Note] Plugin 'FEDERATED' is disabled.
100703 17:51:36 InnoDB: Started; log sequence number 0 44233
Can't create IP socket: No such file or directory
100703 17:51:36 [ERROR] Aborting100703 17:51:36 InnoDB: Starting shutdown...
100703 17:51:41 InnoDB: Shutdown completed; log sequence number 0 44233
100703 17:51:41 [Note] C:\mysql\bin\mysqld: Shutdown complete
哦,看看socket参数等于多少?c:\windows\my.ini
将其改为socket=/mysql.sock