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

AMH 社区首页

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

[求助帖] Mysql链接出错

dreamwyq
铁牌会员
11.00 价值分

dreamwyq 发表于 2015-12-04 13:31:42
[Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysql-generic-5.5.40.sock' (2) Mysql链接出错,请配置/Amysql/config.php文件。#
/etc/init.d/amh-start尝试重启后的mysql这是怎么了?
我之前用yum update 更新了一下系统
[Linux] AMH 5.2
http://amh.sh

[mysql-generic-5.5.40 boot]
=============================================================
[OK] mysql-generic-5.5.40 is already installed.
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/iZ253g1uxptZ.pid).
151103 18:28:55 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5.40
151103 18:28:55 [Note] Plugin 'InnoDB' is disabled.
151103 18:28:55 [Note] Plugin 'FEDERATED' is disabled.
151103 18:28:55 [Note] Event Scheduler: Loaded 0 events
151103 18:28:55 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for connections.
Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL)
151103 21:57:13 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdown

151103 21:57:13 [Note] Event Scheduler: Purging the queue. 0 events
151103 21:57:15 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing close of thread 677 user: 'root'

151103 21:57:15 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown complete

151103 21:57:15 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5.40/mysql.pid ended
151103 21:57:16 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5.40
151103 21:57:16 [Note] Plugin 'InnoDB' is disabled.
151103 21:57:16 [Note] Plugin 'FEDERATED' is disabled.
151103 21:57:16 [Note] Event Scheduler: Loaded 0 events
151103 21:57:16 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for connections.
Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL)
151103 22:11:46 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdown

151103 22:11:46 [Note] Event Scheduler: Purging the queue. 0 events
151103 22:11:48 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing close of thread 43 user: 'root'

151103 22:11:48 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown complete

151103 22:11:48 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5.40/mysql.pid ended
151103 22:11:49 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5.40
151103 22:11:49 [Note] Plugin 'InnoDB' is disabled.
151103 22:11:49 [Note] Plugin 'FEDERATED' is disabled.
151103 22:11:49 [Note] Event Scheduler: Loaded 0 events
151103 22:11:49 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for connections.
Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL)
151104 8:35:56 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdown

151104 8:35:56 [Note] Event Scheduler: Purging the queue. 0 events
151104 8:35:58 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing close of thread 11142 user: 'root'

151104 8:35:58 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown complete

151104 08:35:58 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5.40/mysql.pid ended
151104 08:35:59 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5.40
151104 8:35:59 [Note] Plugin 'InnoDB' is disabled.
151104 8:35:59 [Note] Plugin 'FEDERATED' is disabled.
151104 8:35:59 [Note] Event Scheduler: Loaded 0 events
151104 8:35:59 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for connections.
Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL)
151104 8:57:06 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdown

151104 8:57:06 [Note] Event Scheduler: Purging the queue. 0 events
151104 8:57:08 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing close of thread 382 user: 'root'

151104 8:57:08 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown complete

151104 08:57:08 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5.40/mysql.pid ended
151104 08:57:09 mysqld_safe Starting mysqld daemon with databases from /home/usrdata/mysql-generic-5.5.40
151104 8:57:09 [Note] Plugin 'InnoDB' is disabled.
151104 8:57:09 [Note] Plugin 'FEDERATED' is disabled.
151104 8:57:10 [Note] Event Scheduler: Loaded 0 events
151104 8:57:10 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for connections.
Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL)

Status information:

Current dir: /home/usrdata/mysql-generic-5.5.40/
Running threads: 0 Stack size: 262144
Current locks:
lock: 0x7f007c0facb0:

lock: 0x7f007c223340:

lock: 0x7f007c21fb50:

lock: 0x7f007c0bada0:

lock: 0x7f008006a980:

lock: 0x7f00800fdc40:

lock: 0x7f0080090720:

lock: 0x7f00800f82d0:

lock: 0x7f00800a2de0:

lock: 0x7f0080138f50:

lock: 0x7f008017e270:

lock: 0x7f0080113000:

lock: 0x7f008011cbe0:

lock: 0x7f0080111f20:

lock: 0x7f008006d110:

lock: 0x7f0080110a90:

lock: 0x7f007c1d6ce0:

lock: 0x7f00800bfe40:

lock: 0x7f00800c8050:

lock: 0x7f008007af00:

lock: 0x7f0080109050:

lock: 0x7f00800f6550:

lock: 0x7f008017b350:

lock: 0x7f00801283e0:

lock: 0x7f0080118a70:

lock: 0x7f0080126050:

lock: 0x7f007c18b5c0:

lock: 0x7f007c193180:

lock: 0x7f007c0e6e40:

lock: 0x7f0080106410:

lock: 0x7f0080040b80:

lock: 0x7f007c155fa0:

lock: 0x7f007c027a70:

lock: 0x7f007c14e920:

lock: 0x7f007c00d3d0:

lock: 0x7f007c1f5a90:

lock: 0x7f007c18fcd0:

lock: 0x7f007c0635c0:

lock: 0x7f007c067050:

lock: 0x7f007c0d7570:

lock: 0x7f007c0d1ea0:

lock: 0x7f007c0f02c0:

lock: 0x7f007c1a0040:

lock: 0x7f008008dda8:

lock: 0x7f00800110c8:

lock: 0x7f007c122d30:

lock: 0x7f007c1f8330:

lock: 0x7f008c08d910:

lock: 0x7f007c14fcf0:

lock: 0x7f007c06b7c0:

lock: 0x7f007c0da2f0:

lock: 0x7f007c1ba790:

lock: 0x7f007c1e7c40:

lock: 0x7f007c1e4b30:

lock: 0x7f007c1e0c90:

lock: 0x7f007c1cbbb0:

lock: 0x7f007c15b2d0:

lock: 0x7f007c170eb0:

lock: 0x7f007c137550:

lock: 0x7f007c05b710:

lock: 0x7f007c053d30:

lock: 0x7f007c04f120:

lock: 0x7f007c043d70:

lock: 0x7f007c01c100:

lock: 0x7f007c011970:

lock: 0x7f00901c8478:

lock: 0x7f009065c5f8:

lock: 0x7f00902b4548:

lock: 0x7f00902a8188:

lock: 0x7f00905e4f28:

lock: 0x7f008c13a128:

lock: 0x7f008c2a2ba8:

lock: 0x7f008c22d688:

lock: 0x7f008c11c588:

lock: 0x7f008c279728:

lock: 0x7f008c1fd538:

lock: 0x7f008c250858:

lock: 0x7f008c115958:

lock: 0x7f008c064bd8:

lock: 0xf3fae0:

lock: 0xf402c0:

lock: 0xf401e0:

lock: 0xf40100:

lock: 0xf3fca0:

lock: 0xf3fbc0:

lock: 0xf3fa00:

lock: 0xf3f920:

lock: 0xf3f840:

lock: 0xf403a0:

lock: 0xf3fd80:

lock: 0xf40020:

lock: 0xf3ff40:

lock: 0xf3fe60:

lock: 0xf3f760:

lock: 0xf3f680:

lock: 0xf3f5a0:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 4510
not flushed: 0
w_requests: 552078
writes: 488207
r_requests: 263932712
reads: 49673


handler status:
read_key: 3815727
read_next: 3273888677
read_rnd 236574418
read_first: 537755
write: 1738113
delete 24278
update: 618106

Table status:
Opened tables: 60888
Open tables: 64
Open files: 129
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 32849920
Number of free chunks: 1002
Number of fastbin blocks: 20
Number of mmapped regions: 3
Space in mmapped regions: 17604608
Maximum total allocated space: 0
Space available in freed fastbin blocks: 1136
Total allocated space: 6589936
Total free space: 26259984
Top-most, releasable space: 259696
Estimated memory (with thread stack): 50454528



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:139
LUA : init_queue:149
WOC : NO
Next activation : never
151204 10:25:25 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdown

151204 10:25:25 [Note] Event Scheduler: Purging the queue. 0 events
151204 10:25:25 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown complete

151204 10:25:25 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5.40/mysql.pid ended
[Error] mysql-generic-5.5.40 start failed.
2015-12-04 13:31:42 1

amysql
创始人
99530.81 价值分

工单已经处理。
有重复的my.cnf配置文件。
  支持 (0分)  反对 (0分)
回复  2015-12-15 13:01:56 2

AMH面板 - 好用高效低占用、安全可靠极稳定

ykl
铁牌会员
22.00 价值分

引用:
amysql 发表于 2015-12-15 13:01
工单已经处理。
有重复的my.cnf配置文件。


我也出现同样的问题了
  支持 (0分)  反对 (0分)
回复  2016-04-23 18:51:46 4

wzker
铁牌会员
1.00 价值分

我也是同样问题,不知怎么回事,在etc下发现多出来个my.cnf
  支持 (0分)  反对 (0分)
回复  2016-07-17 16:10:10 5

搬砖少年
银牌会员
1152.41 价值分

一样的,今儿突然就登陆不上后台了
  支持 (0分)  反对 (0分)
回复  2016-07-17 23:48:47 6

islogin
铁牌会员
1.00 价值分

怎么解决呢?我的也是
  支持 (0分)  反对 (0分)
回复  2016-08-17 14:33:37 7

阿豪
铁牌会员
2.00 价值分

新建的LNMP环境为什么无法链接到数据库
  支持 (0分)  反对 (0分)
回复  2016-08-17 21:42:47 8

xinhong_liu
铁牌会员
2.00 价值分

我也是这个问题,怎么处理的?
  支持 (0分)  反对 (0分)
回复  2016-08-25 00:44:32 9

qdkxcy
铁牌会员
1.00 价值分

借个位置 请问下 怎样发主题帖子?
  支持 (0分)  反对 (0分)
回复  2016-08-25 17:40:23 10
 1  (总1页)
AMH社区列表
用户服务中心