130522 8:34:56 [Note] Plugin 'FEDERATED' is disabled. 130522 8:34:57 InnoDB: Initializing buffer pool, size = 42.0M 130522 8:34:57 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 130522 8:34:57 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130522 8:34:57 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 130522 8:34:57 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 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 130522 8:34:58 InnoDB: Started; log sequence number 0 0 130522 8:34:58 [ERROR] Do you already have another mysqld server running on port: 3306 ? 130522 8:34:58 [ERROR] Aborting130522 8:34:58 InnoDB: Starting shutdown... 130522 8:35:03 InnoDB: Shutdown completed; log sequence number 0 44233 130522 8:35:03 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete 有2个机器都是同一个问题。。
130522 8:36:14 [Note] Plugin 'FEDERATED' is disabled. 130522 8:36:14 InnoDB: Initializing buffer pool, size = 42.0M 130522 8:36:14 InnoDB: Completed initialization of buffer pool 130522 8:36:14 InnoDB: Started; log sequence number 0 44233 130522 8:36:14 [ERROR] Do you already have another mysqld server running on port: 3306 ? 130522 8:36:14 [ERROR] Aborting130522 8:36:14 InnoDB: Starting shutdown... 130522 8:36:19 InnoDB: Shutdown completed; log sequence number 0 44233 130522 8:36:19 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete130522 8:39:57 [Note] Plugin 'FEDERATED' is disabled. 130522 8:39:58 InnoDB: Initializing buffer pool, size = 42.0M 130522 8:39:58 InnoDB: Completed initialization of buffer pool 130522 8:39:59 InnoDB: Started; log sequence number 0 44233 130522 8:43:57 [Note] Event Scheduler: Loaded 0 events 130522 8:43:57 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.54-community' socket: '' port: 3306 MySQL Community Server (GPL) 130522 8:50:42 8:39后是重启后的启动日志 求版主帮忙。
怎么不是默认用的innodb引擎吗
就没彻底停掉mysql服务啊 你直接进任务管理器kill掉mysqld 在启动
是用的innodb引擎啊
不在cmd下net stop mysql? 直接任务管理器K掉进程?
130522 8:43:57 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.54-community' socket: '' port: 3306 MySQL Community Server (GPL) 130522 8:50:42 这已经显示启动成功了。 参考下贴中的检查方法并贴出你的检查结果(#43楼)http://topic.csdn.net/u/20090920/22/14d4f597-b7d4-4c24-b0db-abb2956e66c3.html [收集]mysql 无法联接故障现象及原因
这是我重启之后才提示启动成功,重启之前提示130522 8:36:14 [Note] Plugin 'FEDERATED' is disabled. 130522 8:36:14 InnoDB: Initializing buffer pool, size = 42.0M 130522 8:36:14 InnoDB: Completed initialization of buffer pool 130522 8:36:14 InnoDB: Started; log sequence number 0 44233 130522 8:36:14 [ERROR] Do you already have another mysqld server running on port: 3306 ? 130522 8:36:14 [ERROR] Aborting
130522 8:36:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?这句话的意思是,你已经有一个MYSQL服务在运行了。你是如何 "然后我停掉mysql 再启动"应该是MYSQL服务还没有停止,就开始启动了。
我net stop mysql 后查看进程,没有mysql进程才又启动的。请问这种状况如何解决?停止后隔段时间再启动?
net stop mysql ->检查进程->清空错误日志->启动MYSQL 看看 错误日志中的信息 不会有其它程序启动MYSQL吧?
错误日志中的信息
130522 8:34:57 InnoDB: Initializing buffer pool, size = 42.0M
130522 8:34:57 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130522 8:34:57 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130522 8:34:57 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130522 8:34:57 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 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
130522 8:34:58 InnoDB: Started; log sequence number 0 0
130522 8:34:58 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130522 8:34:58 [ERROR] Aborting130522 8:34:58 InnoDB: Starting shutdown...
130522 8:35:03 InnoDB: Shutdown completed; log sequence number 0 44233
130522 8:35:03 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
有2个机器都是同一个问题。。
130522 8:36:14 InnoDB: Initializing buffer pool, size = 42.0M
130522 8:36:14 InnoDB: Completed initialization of buffer pool
130522 8:36:14 InnoDB: Started; log sequence number 0 44233
130522 8:36:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130522 8:36:14 [ERROR] Aborting130522 8:36:14 InnoDB: Starting shutdown...
130522 8:36:19 InnoDB: Shutdown completed; log sequence number 0 44233
130522 8:36:19 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete130522 8:39:57 [Note] Plugin 'FEDERATED' is disabled.
130522 8:39:58 InnoDB: Initializing buffer pool, size = 42.0M
130522 8:39:58 InnoDB: Completed initialization of buffer pool
130522 8:39:59 InnoDB: Started; log sequence number 0 44233
130522 8:43:57 [Note] Event Scheduler: Loaded 0 events
130522 8:43:57 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.54-community' socket: '' port: 3306 MySQL Community Server (GPL)
130522 8:50:42 8:39后是重启后的启动日志 求版主帮忙。
你直接进任务管理器kill掉mysqld 在启动
直接任务管理器K掉进程?
Version: '5.1.54-community' socket: '' port: 3306 MySQL Community Server (GPL)
130522 8:50:42
这已经显示启动成功了。 参考下贴中的检查方法并贴出你的检查结果(#43楼)http://topic.csdn.net/u/20090920/22/14d4f597-b7d4-4c24-b0db-abb2956e66c3.html
[收集]mysql 无法联接故障现象及原因
这是我重启之后才提示启动成功,重启之前提示130522 8:36:14 [Note] Plugin 'FEDERATED' is disabled.
130522 8:36:14 InnoDB: Initializing buffer pool, size = 42.0M
130522 8:36:14 InnoDB: Completed initialization of buffer pool
130522 8:36:14 InnoDB: Started; log sequence number 0 44233
130522 8:36:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130522 8:36:14 [ERROR] Aborting
130522 8:36:14 InnoDB: Starting shutdown...
130522 8:36:19 InnoDB: Shutdown completed; log sequence number 0 44233
130522 8:36:19 [Note] F:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
错误1067
我net stop mysql 后查看进程,没有mysql进程才又启动的。请问这种状况如何解决?停止后隔段时间再启动?
看看 错误日志中的信息
不会有其它程序启动MYSQL吧?
netstat -ano
杀掉
然后重启应该就好了吧
还有能不能不重启 当mysql假死后 我结束进程后 怎么才能让他直接开启?也就是说如何解决端口占用这个问题?
我net stop mysql 后查看进程,没有mysql进程才又启动的。请问这种状况如何解决?停止后隔段时间再启动?把防火墙先关了。
我net stop mysql 后查看进程,没有mysql进程才又启动的。请问这种状况如何解决?停止后隔段时间再启动?把防火墙先关了。防火墙是关闭的。