MySQL数据库重启时出现的问题

supermarx

160324 12:25:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/bogon.pid ended
160324 12:56:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160324 12:56:21 [Note] Plugin 'InnoDB' is disabled.
160324 12:56:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160324 12:56:21 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160324 12:56:21 [Note] Server socket created on IP: '0.0.0.0'.
160324 12:56:21 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
160324 12:56:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160324 12:56:21 [ERROR] Aborting

160324 12:56:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete





151117 17:14:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.pid ended
151117 17:21:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
151117 17:21:11 [Note] Plugin 'InnoDB' is disabled.
151117 17:21:11 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151117 17:21:11 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151117 17:21:11 [Note] Server socket created on IP: '0.0.0.0'.
151117 17:21:11 [Note] Event Scheduler: Loaded 0 events
151117 17:21:11 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
151117 18:02:46 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

151117 18:02:46 [Note] Event Scheduler: Purging the queue. 0 events
151117 18:02:48 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151117 18:02:48 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.pid ended

licess

160324 12:56:21 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
160324 12:56:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
160324 12:56:21 [ERROR] Aborting

可能有程序占用了mysql端口，可以lsof -i:3306 确认一下是哪个程序，然后kill掉