HTTPS
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
eplanx |
eplanx 发表于 2015-09-17 21:47:33
[Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysql-generic-5.5.40.sock' (2) Mysql链接出错，请配置/Amysql/config.php文件。#
自己手贱，在面板重启了下mysql，出现如上问题，在论坛找了半天解决方案，他们都是磁盘空间不足，而我的磁盘空间很大的！ 尝试关闭mysql （ amh mysql stop ）然后重新启动（amh mysql start）依旧无效！ 目录权限 -rw-r----- 1 mysql root 10500 Sep 17 21:41 VM_72_31_centos.err drwx------ 2 mysql mysql 4096 Jul 28 19:05 amh drwx------ 2 mysql mysql 4096 Jul 6 18:47 mysql -rw-rw---- 1 mysql mysql 0 Sep 17 20:52 mysql-bin.index drwx------ 2 mysql mysql 4096 Jul 6 18:47 performance_schema 检测my.cnf配置是否正确(与是否有多余其它的） 这项没有 下面是错误提示 求解决！谢谢了 [mysql start] ============================================================= ============================================================= [Linux] AMH 5.1 http://amh.sh [mysql-generic-5.5.40 start] ============================================================= mysql-generic-5.5.40 [OK] mysql-generic-5.5.40 is already installed. Starting MySQL. ERROR! The server quit without updating PID file (/home/usrdata/ mysql-generic-5.5.40/mysql.pid). 150706 18:47:05 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150706 18:47:06 [Note] Plugin 'InnoDB' is disabled. 150706 18:47:06 [Note] Plugin 'FEDERATED' is disabled. 150706 18:47:06 [Note] Event Scheduler: Loaded 0 events 150706 18:47:06 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150706 22:20:13 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdo wn 150706 22:20:13 [Note] Event Scheduler: Purging the queue. 0 events 150706 22:20:15 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing cl ose of thread 338 user: 'root' 150706 22:20:15 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown comp lete 150706 22:20:15 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5 .40/mysql.pid ended 150706 22:20:16 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150706 22:20:16 [Note] Plugin 'InnoDB' is disabled. 150706 22:20:16 [Note] Plugin 'FEDERATED' is disabled. 150706 22:20:16 [Note] Event Scheduler: Loaded 0 events 150706 22:20:16 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150710 20:22:31 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdo wn 150710 20:22:31 [Note] Event Scheduler: Purging the queue. 0 events 150710 20:22:31 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown comp lete  点赞，加油！ (0分)
2015-09-17 21:47:33 1
|
|
eplanx |
150710 20:22:31 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5 .40/mysql.pid ended
150710 20:23:23 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150710 20:23:26 [Note] Plugin 'InnoDB' is disabled. 150710 20:23:26 [Note] Plugin 'FEDERATED' is disabled. 150710 20:23:27 [Note] Event Scheduler: Loaded 0 events 150710 20:23:27 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150723 21:06:15 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150723 21:06:21 [Note] Plugin 'InnoDB' is disabled. 150723 21:06:21 [Note] Plugin 'FEDERATED' is disabled. 150723 21:06:22 [Note] Event Scheduler: Loaded 0 events 150723 21:06:22 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150724 06:21:57 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150724 6:22:04 [Note] Plugin 'InnoDB' is disabled. 150724 6:22:04 [Note] Plugin 'FEDERATED' is disabled. 150724 6:22:04 [Note] Event Scheduler: Loaded 0 events 150724 6:22:04 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150728 19:23:10 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150728 19:23:16 [Note] Plugin 'InnoDB' is disabled. 150728 19:23:16 [Note] Plugin 'FEDERATED' is disabled. 150728 19:23:16 [Note] Event Scheduler: Loaded 0 events 150728 19:23:16 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150728 19:27:44 mysqld_safe A mysqld process already exists 150728 19:39:35 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150728 19:39:37 [Note] Plugin 'InnoDB' is disabled. 150728 19:39:37 [Note] Plugin 'FEDERATED' is disabled. 150728 19:39:37 [Note] Event Scheduler: Loaded 0 events 150728 19:39:37 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: ready for con nections. Version: '5.5.40-log' socket: '/tmp/mysql-generic-5.5.40.sock' port: 0 MySQL Community Server (GPL) 150728 19:53:49 mysqld_safe A mysqld process already exists 150728 20:16:02 mysqld_safe A mysqld process already exists 150917 20:34:45 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Normal shutdo wn 150917 20:34:45 [Note] Event Scheduler: Purging the queue. 0 events 150917 20:34:47 [Warning] /usr/local/mysql-generic-5.5.40/bin/mysqld: Forcing cl ose of thread 15386 user: 'root' 150917 20:52:31 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown comp lete 150917 20:52:31 mysqld_safe mysqld from pid file /home/usrdata/mysql-generic-5.5 .40/mysql.pid ended 150917 20:56:40 mysqld_safe Starting mysqld daemon with databases from /home/usr data/mysql-generic-5.5.40 150917 20:56:40 [Note] Plugin 'InnoDB' is disabled. 150917 20:56:40 [Note] Plugin 'FEDERATED' is disabled. 150917 20:56:40 [ERROR] /usr/local/mysql-generic-5.5.40/bin/mysqld: unknown opti on '--skip name resolve' 150917 20:56:40 [ERROR] Aborting 150917 21:05:39 [Note] /usr/local/mysql-generic-5.5.40/bin/mysqld: Shutdown comp lete 150917 21:05:39 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-09-17 21:48:13 2
|
|
eplanx |
Mysql 配置文件
[client] port = 3306 socket = /tmp/mysql-generic-5.5.40.sock [mysqld] default-storage-engine = MyISAM innodb = OFF skip-innodb port = 3306 socket = /tmp/mysql-generic-5.5.40.sock lc-messages-dir=/usr/local/mysql-generic-5.5.40/share basedir = /usr/local/mysql-generic-5.5.40 datadir = /home/usrdata/mysql-generic-5.5.40 pid-file = /home/usrdata/mysql-generic-5.5.40/mysql.pid 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 skip-networking skip name resolve [mysqldump] quick [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
回复
2015-09-17 21:51:49 3
|
|
amysql |
工单已解决。修改配置错误原因。
回复
2015-09-23 15:28:11 4
AMH面板 - 好用高效低占用、安全可靠极稳定 |
|
jialong520 |
工单？到哪提？怎么提？
能把解决问题的具体方法到这贴出来？
回复
2015-10-09 16:53:47 5
|
|
象之若 |
引用: amysql 发表于 2015-9-23 15:28  工单已解决。修改配置错误原因。 我和他遇到了一样的错误，配置文件也是一样的，请问如何解决这个问题？
回复
2016-04-14 00:42:44 6
|
[求助帖]
[Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysq...
