AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] Mysql链接出错 |
|
---|---|
dreamwyq |
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.
点赞,加油! (0分)
2015-12-04 13:31:42 1
|
amysql |
工单已经处理。
有重复的my.cnf配置文件。
回复
2015-12-15 13:01:56 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
ykl |
回复
2016-04-23 18:51:46 4
|
wzker |
我也是同样问题,不知怎么回事,在etc下发现多出来个my.cnf
回复
2016-07-17 16:10:10 5
|
搬砖少年 |
一样的,今儿突然就登陆不上后台了
回复
2016-07-17 23:48:47 6
|
islogin |
怎么解决呢?我的也是
回复
2016-08-17 14:33:37 7
|
阿豪 |
新建的LNMP环境为什么无法链接到数据库
回复
2016-08-17 21:42:47 8
|
xinhong_liu |
我也是这个问题,怎么处理的?
回复
2016-08-25 00:44:32 9
|
qdkxcy |
借个位置 请问下 怎样发主题帖子?
回复
2016-08-25 17:40:23 10
|