supermarx 发表于 2016-3-24 17:51:26

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

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 Plugin 'InnoDB' is disabled.
160324 12:56:21 Server hostname (bind-address): '0.0.0.0'; port: 3306
160324 12:56:21    - '0.0.0.0' resolves to '0.0.0.0';
160324 12:56:21 Server socket created on IP: '0.0.0.0'.
160324 12:56:21 Can't start server: Bind on TCP/IP port: Address already in use
160324 12:56:21 Do you already have another mysqld server running on port: 3306 ?
160324 12:56:21 Aborting

160324 12:56:21 /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 Plugin 'InnoDB' is disabled.
151117 17:21:11 Server hostname (bind-address): '0.0.0.0'; port: 3306
151117 17:21:11    - '0.0.0.0' resolves to '0.0.0.0';
151117 17:21:11 Server socket created on IP: '0.0.0.0'.
151117 17:21:11 Event Scheduler: Loaded 0 events
151117 17:21:11 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151117 18:02:46 /usr/local/mysql/bin/mysqld: Normal shutdown

151117 18:02:46 Event Scheduler: Purging the queue. 0 events
151117 18:02:48 /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 发表于 2016-3-24 19:49:43

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

可能有程序占用了mysql端口,可以lsof -i:3306 确认一下是哪个程序,然后kill掉
页: [1]
查看完整版本: MySQL数据库重启时出现的问题