产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[求助帖] 郁闷啊,mysql无法启动了。

moliliang
铁牌会员
173.00 价值分

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分)   有, 感谢 (0分)
2014-02-14 10:16:24 1

tanyuxiang
金牌会员
5420.37 价值分

df -h
ps -ef | grep mysql

kill 。。。


amh mysql restart
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 10:36:55 2

moliliang
铁牌会员
173.00 价值分

引用:
tanyuxiang 发表于 2014-2-14 10:36
df -h
ps -ef | grep mysql



df -h 肯定是没有问题的,基本上都是20%以下。

kill 后。。还是一样。。。
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 10:58:42 3

tanyuxiang
金牌会员
5420.37 价值分

cd到data
ll
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:04:28 4

moliliang
铁牌会员
173.00 价值分

引用:
tanyuxiang 发表于 2014-2-14 11:04
cd到data
ll


|| 是啥意思
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:25:46 5

tanyuxiang
金牌会员
5420.37 价值分

小写LL
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:26:38 6

moliliang
铁牌会员
173.00 价值分

引用:
tanyuxiang 发表于 2014-2-14 11:26
小写LL


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
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:40:36 7

moliliang
铁牌会员
173.00 价值分

引用:
tanyuxiang 发表于 2014-2-14 11:26
小写LL


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/
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:42:17 8

tanyuxiang
金牌会员
5420.37 价值分

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
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:48:09 9

moliliang
铁牌会员
173.00 价值分

引用:
tanyuxiang 发表于 2014-2-14 11:48
LL没问题




/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).



:'( 还是不行。。
评价: 这个答复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-14 11:54:17 10
 1 2 >  (总2页)
AMH社区列表
用户服务中心