无法在wnidows 7计算机上将MySql作为服务启动 [英] Unable to start MySql as a service on a wnidows 7 machine

问题描述

我是MYsql的新手，并下载了mysql-installer-community-5.6.14.0并尝试安装. 但是此过程在配置步骤中停止了.我尝试使用Google搜索2天，但找不到解决方案.我已经将mysql作为Windows服务运行为本地系统服务，当我尝试启动它时，pc.err文件中出现以下错误

I am new to MYsql and have downloaded mysql-installer-community-5.6.14.0 and tried to install. But this process stopped at the configuration step. I tried googling for 2 days but was unable to find the solution. I have made mysql as a windows service to run as local system service and when i try to start it the following error comes in pc.err file

2013-10-20 09:28:40 3312 [Note] Plugin 'FEDERATED' is disabled.
2013-10-20 09:28:40 3312 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-10-20 09:28:40 1974 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-10-20 09:28:40 3312 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-20 09:28:40 3312 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-20 09:28:40 3312 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-20 09:28:40 3312 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-20 09:28:40 3312 [Note] InnoDB: Initializing buffer pool, size = 200.0M
2013-10-20 09:28:40 3312 [Note] InnoDB: Completed initialization of buffer pool
2013-10-20 09:28:40 3312 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-20 09:28:41 3312 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-20 09:28:41 3312 [Note] InnoDB: Waiting for purge to start
2013-10-20 09:28:41 3312 [Note] InnoDB: 5.6.14 started; log sequence number 1626017
2013-10-20 09:28:41 3312 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-20 09:28:41 3312 [Note] IPv6 is available.
2013-10-20 09:28:41 3312 [Note]   - '::' resolves to '::';
2013-10-20 09:28:41 3312 [Note] Server socket created on IP: '::'.
**2013-10-20 09:28:41 3312 [ERROR] Can't start server: listen() on TCP/IP port: No such file or directory
2013-10-20 09:28:41 3312 [ERROR] listen() on TCP/IP failed with error 0
2013-10-20 09:28:41 3312 [ERROR] Aborting**
Please help as I am a newbie am not able to get anything.
Thanks in advance
Raghu dev

推荐答案

打开命令提示符，然后键入"netstat -an "，不带引号.

Open command prompt and type "netstat -an" without the quotes.

您可以查看打开的端口列表.如果端口3306被其他进程使用，则将 my.ini 中的端口修改为端口 3307 或没有其他sservice使用的其他端口，然后重新启动 MySQL 服务，它应该接收更改.

You can view the list of ports that are open. If the port 3306 is used by some other process, then modify the port in my.ini to port 3307 or some other port which no other sservice is using and restart the MySQL service, it should pick up the change.

这篇关于无法在wnidows 7计算机上将MySql作为服务启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！