有关mysql服务自动关闭的问题 我用的是MySQL Server5.0绿色版的,我给它开了3506端口在有些计算机上,过没多久它就会自动关闭,但有些计算机上又不会这个问题该怎么处理啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 cmd --> F:\MySql\MySqlServer5.1\bin\mysqld --install 加入服务 这个啊?那么少信息比较难判断这样吧你去看看data的目录下err后缀的文件里面是否有什么错误信息没有?或去看看操作系统的日志,看看是否有什么异常错误信息没有 确认下是否存在socket端口冲突的问题没有 091030 10:58:14 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...091030 10:58:14 InnoDB: Starting log scan based on checkpoint atInnoDB: log sequence number 0 6242273.InnoDB: Doing recovery: scanned up to log sequence number 0 6242273091030 10:58:14 InnoDB: Started; log sequence number 0 6242273091030 10:58:15 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)091030 11:09:30 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 11:09:30 InnoDB: Starting shutdown...091030 11:09:34 InnoDB: Shutdown completed; log sequence number 0 6244096091030 11:09:34 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 11:10:44 InnoDB: Started; log sequence number 0 6244096091030 11:10:46 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)091030 11:35:43 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 11:35:43 InnoDB: Starting shutdown...091030 11:35:45 InnoDB: Shutdown completed; log sequence number 0 6244096091030 11:35:45 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 11:36:53 InnoDB: Started; log sequence number 0 6244096091030 11:36:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)091030 12:30:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 12:30:55 InnoDB: Starting shutdown...091030 12:30:58 InnoDB: Shutdown completed; log sequence number 0 6249370091030 12:30:58 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 12:31:53 InnoDB: Started; log sequence number 0 6249370091030 12:31:53 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)091030 12:57:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 12:57:55 InnoDB: Starting shutdown...091030 12:57:57 InnoDB: Shutdown completed; log sequence number 0 6251418091030 12:57:57 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 13:16:13 InnoDB: Started; log sequence number 0 6251418091030 13:16:14 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)这玩意儿看不太明白 mysql本来就是开源的东西,community版本又不收钱,为什么还去搞绿色版呢?mysql中有个连接时间限制,默认是8小时 从ERR LOG上看不出什么问题,到你的WINDOWS的事件查看器中看一下有什么异常。另外,建议不要用中文目录 d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\ 为了用户安装的方便不用绿色版的话得先安装mysql才能安装我们的软件 现在发现,这些都不是关键问题,mysql进程让360给杀了~~~ mysql被杀了以后怎么办呢?我也碰到这个问题了?重装mysql吗?然后加为信任还是直接把360扔了算了? 关于主外键约束和测试数据问题 查询MYSQL 两个字段的重复值。 请教MYSQL高手。关于二进制操作文件提取。 load data 导入时怎么识别 int 型和字符型? 取得一个表中的某一列的排名 mysql中文不显示 配置信息更改过 MySQL用C语言不能insert中文,请教该怎么解决?在线等,谢谢!谢谢! MS SQL与MySQL语句的转换问题 now()可否做建表的默认项? 本版将要强行结帖,请各位注意自己的帖子! 提问:使用OR的查询为什么执行计划不使用索引? 如何不让mysqlslap删除生成后的数据。
那么少信息比较难判断
这样吧
你去看看data的目录下err后缀的文件里面是否有什么错误信息没有?
或去看看操作系统的日志,看看是否有什么异常错误信息没有
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
091030 10:58:14 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 6242273.
InnoDB: Doing recovery: scanned up to log sequence number 0 6242273
091030 10:58:14 InnoDB: Started; log sequence number 0 6242273
091030 10:58:15 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)
091030 11:09:30 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 11:09:30 InnoDB: Starting shutdown...
091030 11:09:34 InnoDB: Shutdown completed; log sequence number 0 6244096
091030 11:09:34 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 11:10:44 InnoDB: Started; log sequence number 0 6244096
091030 11:10:46 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)
091030 11:35:43 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 11:35:43 InnoDB: Starting shutdown...
091030 11:35:45 InnoDB: Shutdown completed; log sequence number 0 6244096
091030 11:35:45 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 11:36:53 InnoDB: Started; log sequence number 0 6244096
091030 11:36:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)
091030 12:30:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 12:30:55 InnoDB: Starting shutdown...
091030 12:30:58 InnoDB: Shutdown completed; log sequence number 0 6249370
091030 12:30:58 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 12:31:53 InnoDB: Started; log sequence number 0 6249370
091030 12:31:53 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)
091030 12:57:55 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Normal shutdown091030 12:57:55 InnoDB: Starting shutdown...
091030 12:57:57 InnoDB: Shutdown completed; log sequence number 0 6251418
091030 12:57:57 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: Shutdown complete091030 13:16:13 InnoDB: Started; log sequence number 0 6251418
091030 13:16:14 [Note] d:\Program Files\HIGHSUM_SOFT\合智人事工资管理软件(网络版)\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3506 MySQL Community Edition (GPL)这玩意儿看不太明白
mysql中有个连接时间限制,默认是8小时
为了用户安装的方便
不用绿色版的话得先安装mysql才能安装我们的软件
现在发现,这些都不是关键问题,
mysql进程让360给杀了~~~
我也碰到这个问题了?
重装mysql吗?然后加为信任还是直接把360扔了算了?