AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] 郁闷啊,mysql无法启动了。 |
|
---|---|
moliliang |
moliliang 发表于 2014-02-14 10:16:24
mysql 错误日志
140213 17:32:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140213 17:32:49 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140213 17:32:49 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys' /usr/local/mysql/bin/mysqld: File './mysql-bin.index' not found (Errcode: 13) 140213 17:32:49 [ERROR] Aborting 140213 17:32:49 [Note] 140213 17:32:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140213 17:41:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140213 17:41:17 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140213 17:41:17 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys' /usr/local/mysql/bin/mysqld: File './mysql-bin.index' not found (Errcode: 13) 140213 17:41:17 [ERROR] Aborting 140213 17:41:17 [Note] 140213 17:41:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended amh mysql start 命令提示: [LNMP/Nginx] Amysql Host - AMH 4.2 http://Amysql.com Starting MySQL. * The server quit without updating PID file (/var/run/mysqld/mysqld.pid). 为什么启动不了。。。。。。求助
点赞,加油! (0分)
2014-02-14 10:16:24 1
|
tanyuxiang |
df -h
ps -ef | grep mysql kill 。。。 amh mysql restart
回复
2014-02-14 10:36:55 2
|
moliliang |
df -h 肯定是没有问题的,基本上都是20%以下。 kill 后。。还是一样。。。
回复
2014-02-14 10:58:42 3
|
tanyuxiang |
cd到data
ll
回复
2014-02-14 11:04:28 4
|
moliliang |
回复
2014-02-14 11:25:46 5
|
tanyuxiang |
小写LL
回复
2014-02-14 11:26:38 6
|
moliliang |
140209 16:13:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 140209 16:13:45 [Note] Plugin 'InnoDB' is disabled. 140209 16:13:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140209 16:13:45 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140209 16:13:45 [Note] Server socket created on IP: '0.0.0.0'. 140209 16:13:45 [Note] Event Scheduler: Loaded 0 events 140209 16:13:45 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 140209 16:21:26 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 140209 16:21:26 [Note] Event Scheduler: Purging the queue. 0 events 140209 16:21:26 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140209 16:21:26 mysqld_safe mysqld from pid file /usr/local/mysql/data/moli.pid ended 140209 16:21:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 140209 16:21:28 [Note] Plugin 'InnoDB' is disabled. 140209 16:21:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140209 16:21:28 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140209 16:21:28 [Note] Server socket created on IP: '0.0.0.0'. 140209 16:21:28 [Note] Event Scheduler: Loaded 0 events 140209 16:21:28 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 140210 1:55:01 [Warning] IP address '180.225.203.220' could not be resolved: Name or service not known 140213 16:33:37 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 140213 16:33:37 [Note] Event Scheduler: Purging the queue. 0 events 140213 16:33:38 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140213 16:33:38 mysqld_safe mysqld from pid file /usr/local/mysql/data/moli.pid ended
回复
2014-02-14 11:40:36 7
|
moliliang |
drwxr-xr-x 11 mysql mysql 4096 Feb 13 16:33 ./ drwxr-xr-x 13 mysql mysql 4096 Feb 9 16:13 ../ drwx------ 2 mysql mysql 4096 Feb 9 16:33 amh/ drwx------ 2 mysql mysql 4096 Feb 9 16:46 hur/ -rw-r----- 1 mysql root 1808 Feb 13 16:33 moli.err drwx------ 2 mysql mysql 4096 Feb 9 16:46 molispeed/ drwx------ 2 mysql root 4096 Feb 9 16:13 mysql/ -rw-rw---- 1 mysql mysql 27684 Feb 9 16:13 mysql-bin.000001 -rw-rw---- 1 mysql mysql 1062789 Feb 9 16:13 mysql-bin.000002 -rw-rw---- 1 mysql mysql 9166 Feb 9 16:21 mysql-bin.000003 -rw-rw---- 1 mysql mysql 15906322 Feb 13 16:33 mysql-bin.000004 -rw-rw---- 1 mysql mysql 76 Feb 9 16:21 mysql-bin.index drwx------ 2 mysql mysql 4096 Feb 9 16:13 performance_schema/ drwx------ 2 mysql mysql 20480 Feb 9 16:46 slex/ drwx------ 2 mysql mysql 4096 Feb 9 16:46 tet/ drwx------ 2 mysql mysql 4096 Feb 9 16:46 weiku/ drwx------ 2 mysql mysql 4096 Feb 9 16:46 xio/
回复
2014-02-14 11:42:17 8
|
tanyuxiang |
LL没问题
140210 1:55:01 [Warning] IP address '180.225.203.220' could not be resolved: Name or service not known 修改配置文件 [mysqld] 下面加上 skip-name-resolve
回复
2014-02-14 11:48:09 9
|
moliliang |
/etc# vim my.cnf /etc# amh mysql start ============================================================= [LNMP/Nginx] Amysql Host - AMH 4.2 http://Amysql.com Starting MySQL . * The server quit without updating PID file (/var/run/mysqld/mysqld.pid). :'( 还是不行。。
回复
2014-02-14 11:54:17 10
|