HTTPS
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
390745148 |
390745148 发表于 2020-11-16 13:02:28
浏览器打开提示 [Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Mysql链接出错，请配置/Amysql/config.php文件。#
 点赞，加油！ (0分)
2020-11-16 13:02:28 1
|
|
amysql |
执行命令：
amh mysql start 进行启动mysql看返回哪些信息？
回复
2020-11-16 13:06:52 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
|
390745148 |
提示 Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/data/iZ236cmn1goZ.pid).
回复
2020-11-16 13:11:50 3
|
|
390745148 |
引用: amysql 发表于 2020-11-16 13:06:52  执行命令： amh mysql start 进行启动mysql看返回哪些信息？ 版本4.2 提示信息 Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/data/iZ236cmn1goZ.pid).
回复
2020-11-16 13:12:30 4
|
|
390745148 |
错误日志
# more iZ236cmn1goZ.err 150809 13:04:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 150809 13:04:23 [Note] Plugin 'InnoDB' is disabled. 150809 13:04:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150809 13:04:23 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 150809 13:04:23 [Note] Server socket created on IP: '0.0.0.0'. 150809 13:04:23 [Note] Event Scheduler: Loaded 0 events 150809 13:04:23 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 150809 13:07:46 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 150809 13:07:46 [Note] Event Scheduler: Purging the queue. 0 events 150809 13:07:46 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 150809 13:07:46 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 150809 13:07:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 150809 13:07:49 [Note] Plugin 'InnoDB' is disabled. 150809 13:07:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150809 13:07:49 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 150809 13:07:49 [Note] Server socket created on IP: '0.0.0.0'. 150809 13:07:49 [Note] Event Scheduler: Loaded 0 events 150809 13:07:49 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 150809 14:34:10 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 150809 14:34:10 [Note] Event Scheduler: Purging the queue. 0 events 150809 14:34:10 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 150809 14:34:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 150809 14:35:43 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 150809 14:35:44 [Note] Plugin 'InnoDB' is disabled. 150809 14:35:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150809 14:35:44 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 150809 14:35:44 [Note] Server socket created on IP: '0.0.0.0'. 150809 14:35:44 [Note] Event Scheduler: Loaded 0 events 150809 14:35:44 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 150810 10:01:56 [Warning] IP address '203.171.232.80' could not be resolved: Name or service not known 150810 14:38:23 [Warning] IP address '180.97.106.161' could not be resolved: Name or service not known 150810 14:38:23 [Warning] IP address '180.97.106.37' could not be resolved: Name or service not known 150811 14:08:37 [Warning] IP address '180.97.106.162' could not be resolved: Name or service not known 150813 14:10:07 [Warning] IP address '122.224.6.150' could not be resolved: Name or service not known 150814 13:26:36 [Warning] IP address '180.97.106.36' could not be resolved: Name or service not known 150814 17:47:11 [Warning] IP address '121.40.97.65' could not be resolved: Name or service not known 150815 2:11:21 [Warning] IP address '169.54.233.121' has been resolved to the host name '169.54.233.121-static.reverse.softlayer.com', which resembles IPv4-address itself. 150815 2:31:42 [Warning] IP address '223.100.67.157' could not be resolved: Name or service not known 150815 13:30:38 [Warning] IP address '139.196.26.17' could not be resolved: Name or service not known 150815 20:17:43 [Warning] IP address '120.209.136.201' could not be resolved: Name or service not known 150815 20:54:08 [Warning] IP address '5.39.222.253' could not be resolved: Name or service not known 150815 21:11:37 [Warning] IP address '98.126.15.162' has been resolved to the host name '98.126.15.162.static.krypt.com', which resembles IPv4-address itself. 150815 22:29:38 [Warning] IP address '180.153.42.200' could not be resolved: Name or service not known 150816 3:52:03 [Warning] IP address '118.193.214.177' could not be resolved: Name or service not known 150816 8:03:59 [Warning] IP address '41.160.237.226' could not be resolved: Name or service not known 150816 14:21:43 [Warning] IP address '42.156.250.114' could not be resolved: Name or service not known 150816 14:21:43 [Warning] IP address '42.156.250.114' could not be resolved: Name or service not known 150817 3:12:04 [Warning] IP address '221.192.131.72' could not be resolved: Name or service not known
回复
2020-11-16 13:13:27 5
|
|
amysql |
引用: 390745148 发表于 2020-11-16 13:13:27 错误日志 # more iZ236cmn1goZ.err 150809 13:04:23 mysqld_safe Starting mysqld daemon with databases f... 提供下最新的日志。你这个是15年的日志了。
回复
2020-11-16 13:25:10 6
|
|
amysql |
tail -n 200 iZ236cmn1goZ.err
查看最后200行的日志。
回复
2020-11-16 13:26:34 7
|
|
390745148 |
引用: amysql 发表于 2020-11-16 13:26:34 tail -n 200 iZ236cmn1goZ.err 查看最后200行的日志。 [root@iZ236cmn1goZ data]# tail -n 200 iZ236cmn1goZ.err 201109 15:39:43 [Note] Server socket created on IP: '0.0.0.0'. 201109 15:39:43 [Note] Event Scheduler: Loaded 0 events 201109 15:39:43 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201109 15:40:31 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 201109 15:40:31 [Note] Event Scheduler: Purging the queue. 0 events 201109 15:40:33 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 34 user: 'root' 201109 15:40:33 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201109 15:40:33 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201109 16:08:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201109 16:08:14 [Note] Plugin 'InnoDB' is disabled. 201109 16:08:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201109 16:08:14 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201109 16:08:14 [Note] Server socket created on IP: '0.0.0.0'. 201109 16:08:14 [Note] Event Scheduler: Loaded 0 events 201109 16:08:14 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201109 20:15:16 [Warning] IP address '183.136.225.42' could not be resolved: Name or service not known 201110 0:24:11 [Warning] IP address '122.228.19.79' could not be resolved: Name or service not known 201110 09:28:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201110 9:28:33 [Note] Plugin 'InnoDB' is disabled. 201110 9:28:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201110 9:28:33 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201110 9:28:33 [Note] Server socket created on IP: '0.0.0.0'. 201110 9:28:34 [Note] Event Scheduler: Loaded 0 events 201110 9:28:34 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201110 9:46:26 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 201110 9:46:26 [Note] Event Scheduler: Purging the queue. 0 events 201110 9:46:26 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201110 09:46:26 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201110 09:48:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201110 9:48:00 [Note] Plugin 'InnoDB' is disabled. 201110 9:48:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201110 9:48:00 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201110 9:48:00 [Note] Server socket created on IP: '0.0.0.0'. 201110 9:48:01 [Note] Event Scheduler: Loaded 0 events 201110 9:48:01 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201110 17:32:05 [Warning] IP address '83.97.20.30' has been resolved to the host name '30.20.97.83.ro.ovo.sc', which resembles IPv4-address itself. 201111 3:29:00 [Warning] IP address '106.75.133.148' could not be resolved: Name or service not known 201111 5:52:54 [Warning] IP address '47.101.192.177' could not be resolved: Name or service not known 201112 11:03:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201112 11:03:45 [Note] Plugin 'InnoDB' is disabled. 201112 11:03:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201112 11:03:45 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201112 11:03:45 [Note] Server socket created on IP: '0.0.0.0'. 201112 11:03:45 [Note] Event Scheduler: Loaded 0 events 201112 11:03:45 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201112 11:39:57 [Warning] IP address '183.136.225.42' could not be resolved: Name or service not known 201113 3:36:16 [Warning] IP address '47.52.210.140' could not be resolved: Name or service not known 201113 9:32:25 [Warning] IP address '120.78.225.124' could not be resolved: Name or service not known 201113 10:01:46 [Warning] IP address '83.97.20.30' has been resolved to the host name '30.20.97.83.ro.ovo.sc', which resembles IPv4-address itself. 201113 15:29:55 [Warning] IP address '120.78.231.236' could not be resolved: Name or service not known 201113 17:28:38 [Warning] IP address '47.100.64.9' could not be resolved: Name or service not known 201114 0:36:08 [Warning] IP address '47.94.52.159' could not be resolved: Name or service not known 201114 4:55:19 [Warning] IP address '119.23.174.205' could not be resolved: Name or service not known 201114 21:17:39 [Warning] IP address '47.100.64.86' could not be resolved: Name or service not known 201114 22:48:12 [Warning] IP address '39.107.14.208' could not be resolved: Name or service not known 201115 1:47:17 [Warning] IP address '106.15.52.246' could not be resolved: Name or service not known 201115 5:53:32 [Warning] IP address '47.100.130.114' could not be resolved: Name or service not known 201115 10:23:45 [Warning] IP address '119.23.138.247' could not be resolved: Name or service not known 201115 19:04:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201115 19:04:14 [Note] Plugin 'InnoDB' is disabled. 201115 19:04:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201115 19:04:14 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201115 19:04:14 [Note] Server socket created on IP: '0.0.0.0'. 201115 19:04:14 [Note] Event Scheduler: Loaded 0 events 201115 19:04:14 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201115 20:20:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201115 20:20:58 [Note] Plugin 'InnoDB' is disabled. 201115 20:20:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201115 20:20:58 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201115 20:20:58 [Note] Server socket created on IP: '0.0.0.0'. 201115 20:20:59 [Note] Event Scheduler: Loaded 0 events 201115 20:20:59 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 201116 1:24:23 [Warning] IP address '119.23.174.205' could not be resolved: Name or service not known 201116 5:07:27 [Warning] IP address '47.101.201.15' could not be resolved: Name or service not known 201116 10:30:14 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 201116 10:30:14 [Note] Event Scheduler: Purging the queue. 0 events 201116 10:30:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 10:30:15 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 10:32:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 10:32:00 [Note] Plugin 'InnoDB' is disabled. 201116 10:32:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 10:32:00 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 10:32:00 [Note] Server socket created on IP: '0.0.0.0'. 201116 10:32:00 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 10:32:00 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 10:32:00 [ERROR] Aborting 201116 10:32:00 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 10:32:00 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 11:12:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 11:12:27 [Note] Plugin 'InnoDB' is disabled. 201116 11:12:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 11:12:27 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 11:12:27 [Note] Server socket created on IP: '0.0.0.0'. 201116 11:12:27 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 11:12:27 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 11:12:27 [ERROR] Aborting 201116 11:12:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 11:12:27 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 11:13:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 11:13:17 [Note] Plugin 'InnoDB' is disabled. 201116 11:13:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 11:13:17 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 11:13:17 [Note] Server socket created on IP: '0.0.0.0'. 201116 11:13:17 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 11:13:17 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 11:13:17 [ERROR] Aborting 201116 11:13:17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 11:13:17 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 11:31:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 11:31:36 [Note] Plugin 'InnoDB' is disabled. 201116 11:31:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 11:31:36 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 11:31:36 [Note] Server socket created on IP: '0.0.0.0'. 201116 11:31:36 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 11:31:36 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 11:31:36 [ERROR] Aborting 201116 11:31:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 11:31:36 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 11:32:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 11:32:36 [Note] Plugin 'InnoDB' is disabled. 201116 11:32:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 11:32:36 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 11:32:36 [Note] Server socket created on IP: '0.0.0.0'. 201116 11:32:36 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 11:32:36 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 11:32:36 [ERROR] Aborting 201116 11:32:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 11:32:36 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 12:39:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 12:39:08 [Note] Plugin 'InnoDB' is disabled. 201116 12:39:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 12:39:08 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 12:39:08 [Note] Server socket created on IP: '0.0.0.0'. 201116 12:39:08 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 12:39:08 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 12:39:08 [ERROR] Aborting 201116 12:39:08 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 12:39:08 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 13:07:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 13:07:59 [Note] Plugin 'InnoDB' is disabled. 201116 13:07:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 13:07:59 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 13:07:59 [Note] Server socket created on IP: '0.0.0.0'. 201116 13:07:59 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 13:07:59 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 13:07:59 [ERROR] Aborting 201116 13:07:59 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 13:07:59 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 13:32:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 13:32:30 [Note] Plugin 'InnoDB' is disabled. 201116 13:32:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 13:32:30 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 13:32:30 [Note] Server socket created on IP: '0.0.0.0'. 201116 13:32:30 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 13:32:30 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 13:32:30 [ERROR] Aborting 201116 13:32:30 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 13:32:30 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended 201116 14:14:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 201116 14:14:29 [Note] Plugin 'InnoDB' is disabled. 201116 14:14:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 201116 14:14:29 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 201116 14:14:29 [Note] Server socket created on IP: '0.0.0.0'. 201116 14:14:29 [ERROR] Can't start server : Bind on unix socket: Permission denied 201116 14:14:29 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 201116 14:14:29 [ERROR] Aborting 201116 14:14:30 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 201116 14:14:30 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ236cmn1goZ.pid ended
回复
2020-11-16 14:16:09 8
|
|
390745148 |
另外 我的服务器cpu占用一直是100%状态
回复
2020-11-16 14:17:18 9
|
|
amysql |
引用: 390745148 发表于 2020-11-16 14:16:09 [root@iZ236cmn1goZ data]# tail -n 200 iZ236cmn1goZ.err 201109 15:39:43 [Note] Server socket created... ls -dl /tmp 看 /tmp/ 是否有权限有问题，如果是已经存在 /tmp/mysql.sock的，删除后再启动： rm -f /tmp/mysql.sock amh mysql start cpu用到100%的话，要看什么程序在占用cpu， 可以用top命令查看。
回复
2020-11-16 14:42:20 10
|
[求助帖]
mysql不能启动了，求助
