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新的文件到相应的位置。