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

AMH 社区首页

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

[求助帖] MYSQLS数据库无法启动!!!

biggreentea
铁牌会员
62.00 价值分

biggreentea 发表于 2014-10-23 13:54:27
本帖最后由 biggreentea 于 2014-10-23 14:07 编辑

The server quit without updating PID file (/usr/local/mys ql/data/AY140722043652318e57Z.pid).


2014-10-23 13:54:27 1

biggreentea
铁牌会员
62.00 价值分


client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
default-storage-engine = MyISAM
innodb = OFF
skip-innodb
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin = mysql-bin
binlog_format = mixed
server-id = 1

[mysqldump]
quick

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
  支持 (0分)  反对 (0分)
回复  2014-10-23 14:07:18 2

biggreentea
铁牌会员
62.00 价值分

[LNMP/Nginx] Amysql Host - AMH 4.2
http://Amysql.com


[LNMP/Nginx] Amysql Host - AMH 4.2
http://Amysql.com

error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/AY140722043652318e57Z.pid).
[root@AY140722043652318e57Z ~]# more /usr/local/mysql/data/*err;
140722 05:07:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140722 5:07:57 [Note] Plugin 'InnoDB' is disabled.
140722 5:07:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140722 5:07:57 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140722 5:07:57 [Note] Server socket created on IP: '0.0.0.0'.
140722 5:07:57 [Note] Event Scheduler: Loaded 0 events
140722 5:07:57 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140722 5:15:59 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

140722 5:15:59 [Note] Event Scheduler: Purging the queue. 0 events
140722 5:15:59 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140722 05:15:59 mysqld_safe mysqld from pid file /usr/local/mysql/data/AY140722043652318e57Z.pid ended
140722 05:16:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140722 5:16:02 [Note] Plugin 'InnoDB' is disabled.
140722 5:16:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140722 5:16:02 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140722 5:16:02 [Note] Server socket created on IP: '0.0.0.0'.
140722 5:16:02 [Note] Event Scheduler: Loaded 0 events
140722 5:16:02 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140722 15:57:45 [Warning] IP address '61.158.163.132' has been resolved to the host name '132.163.158.61.ha.cnc', which resembles IPv4
-address itself.
140722 17:28:23 [Warning] IP address '183.60.107.8' could not be resolved: Name or service not known
140723 12:38:44 [Warning] IP address '61.177.119.226' could not be resolved: Name or service not known
140723 12:52:04 [Warning] IP address '58.213.120.44' could not be resolved: Name or service not known
140723 17:11:59 [Warning] IP address '60.190.121.98' could not be resolved: Name or service not known
140723 21:32:54 [Warning] IP address '139.201.126.207' could not be resolved: Name or service not known
140724 19:08:25 [Warning] IP address '61.160.247.134' could not be resolved: Name or service not known
140726 5:10:54 [Warning] IP address '180.96.62.241' could not be resolved: Name or service not known
140726 11:20:58 [Warning] IP address '42.120.145.121' could not be resolved: Name or service not known
140727 1:29:35 [Warning] IP address '223.255.205.210' could not be resolved: Name or service not known
140727 2:38:15 [Warning] IP address '202.10.78.193' could not be resolved: Name or service not known
140727 3:32:57 [Warning] IP address '118.194.227.52' could not be resolved: Name or service not known
140727 15:25:49 [Warning] IP address '58.218.200.104' could not be resolved: Name or service not known
140728 2:06:43 [Warning] IP address '1.93.4.124' could not be resolved: Name or service not known
140728 2:06:44 [Warning] IP address '1.93.4.124' could not be resolved: Name or service not known
  支持 (0分)  反对 (0分)
回复  2014-10-23 14:07:53 3
 1  (总1页)
AMH社区列表
用户服务中心