日期:2014-05-16  浏览次数:20944 次

mysql服务一启就停,高分求解
我原来装的非安装版的MYSQL,用的好好的,突然有一天服务起不来了,错误日志是这样,还生成几个ib_logfile1   ib_logfile   文件.
我重新安装了一遍,非安装版,安装版的MYSQL,运行服务,都出现这样的错误.
我的系统是XP   SP2,这几天也没动过环境,不知道怎么会突然这样.请高手解答.分不够再补.

InnoDB:   The   first   specified   data   file   C:\MySQL   InnoDB   Datafiles\ibdata1   did   not   exist:
InnoDB:   a   new   database   to   be   created!
070904   21:47:48     InnoDB:   Setting   file   C:\MySQL   InnoDB   Datafiles\ibdata1   size   to   10   MB
InnoDB:   Database   physically   writes   the   file   full:   wait...
070904   21:47:48     InnoDB:   Log   file   .\ib_logfile0   did   not   exist:   new   to   be   created
InnoDB:   Setting   log   file   .\ib_logfile0   size   to   38   MB
InnoDB:   Database   physically   writes   the   file   full:   wait...
070904   21:47:50     InnoDB:   Log   file   .\ib_logfile1   did   not   exist:   new   to   be   created
InnoDB:   Setting   log   file   .\ib_logfile1   size   to   38   MB
InnoDB:   Database   physically   writes   the   file   full:   wait...
InnoDB:   Doublewrite   buffer   not   found:   creating   new
InnoDB:   Doublewrite   buffer   created
InnoDB:   Creating   foreign   key   constraint   system   tables
InnoDB:   Foreign   key   constraint   system   tables   created
070904   21:47:51     InnoDB:   Started;   log   sequence   number   0   0
070904   21:47:51   [ERROR]   Do   you   already   have   another   mysqld   server   running   on   port:   3306   ?
070904   21:47:51   [ERROR]   Aborting

070904   21:47:51     InnoDB:   Starting   shutdown...
070904   21:47:53     InnoDB:   Shutdown   completed;   log   sequence   number   0   43655
070904   21:47:53   [Note]   C:\Program   Files\MySQL\MySQL   Server   5.0\bin\mysqld-nt:   Shutdown   complete



------解决方案--------------------
070904 21:47:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
看样子是你的机器上已经有一个MySQL服务在运行了,3306端口已被占用,仔细找找,或者在配置文件中设置其它的端口。
------解决方案--------------------
Do you already have another mysqld server running on port: 3306 ?
很明显3306已经被使用了,可以cmd:netstat -a 检查已起动情况。
------解决方案--------------------
070904 21:47:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070904 21:47:51 [ERROR] Aborting

1、查一下世那个程序占用了3306端口?
2、解决不了的话直接换端口,比如3307。
3、还有一个,删除MYSQL目录下的BIN下的所有文件。然后重新COPY新的文件到相应的位置。