AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] 急急急,在线等帮助,可支付现金求解决mysql无法连接提示... |
|
---|---|
a69106464 |
a69106464 发表于 2015-11-15 01:00:26
本帖最后由 a69106464 于 2015-11-15 01:22 编辑
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 根据论坛的诸多回答,做了很多检测,但是就是不知道是哪里有问题。检测结果如下 目录权限检测结果: ls -l /home/usrdata/mysql* total 14688 drwx------ 2 mysql mysql 4096 Nov 15 00:42 amh -rw-r----- 1 mysql root 3447 Nov 15 00:43 ilovemengmeng.err drwx------ 2 mysql mysql 4096 Nov 14 23:09 mysql -rw-rw---- 1 mysql mysql 27711 Nov 14 23:09 mysql-bin.000001 -rw-rw---- 1 mysql mysql 1070662 Nov 14 23:09 mysql-bin.000002 -rw-rw---- 1 mysql mysql 11182088 Nov 14 23:53 mysql-bin.000003 -rw-rw---- 1 mysql mysql 1341287 Nov 15 00:06 mysql-bin.000004 -rw-rw---- 1 mysql mysql 1377730 Nov 15 00:40 mysql-bin.000005 -rw-rw---- 1 mysql mysql 95 Nov 15 00:06 mysql-bin.index -rw-rw---- 1 mysql mysql 5 Nov 15 00:43 mysql.pid drwx------ 2 mysql mysql 4096 Nov 14 23:09 performance_schema 文件参数如下: [client] port = 3306 socket = /tmp/mysql-5.5.40.sock [mysqld] default-storage-engine = MyISAM innodb = OFF skip-innodb port = 3306 socket = /tmp/mysql-5.5.40.sock lc-messages-dir=/usr/local/mysql-5.5.40/share basedir = /usr/local/mysql-5.5.40 datadir = /home/usrdata/mysql-5.5.40 pid-file = /home/usrdata/mysql-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 binlog_format = mixed server-id = 1 skip-networking [mysqldump] quick [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout 磁盘空间如下: df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 451G 1.8G 426G 1% / tmpfs 1.9G 0 1.9G 0% /dev/shm /dev/sda1 194M 27M 158M 15% /boot 查找相同配置如下: find / -name my.cnf /root/amh/modules/mysql-5.5.40/my.cnf /usr/local/mysql-5.5.40/my.cnf /usr/local/mysql-5.5.40/mysql-test/suite/rpl/my.cnf /usr/local/mysql-5.5.40/mysql-test/suite/federated/my.cnf 重启mysql提示如下: amh mysql start ============================================================= [Linux] AMH 5.2 http://amh.sh [mysql start] ============================================================= ============================================================= [Linux] AMH 5.2 http://amh.sh [mysql-5.5.40 start] ============================================================= mysql-5.5.40 [OK] mysql-5.5.40 is already installed. Starting MySQL SUCCESS! 到底是哪里有问题?求大神,可支付现金求解决
点赞,加油! (0分)
2015-11-15 01:00:26 1
|
522240858 |
1) df -h 看磁盘是否有空间、
2) ls -l /home/usrdata/mysql*目录是否有权限、 3) find / -name my.cnf 查找是否有重复配置, 4) 检查my.cnf配置是否正确。
回复
2015-11-15 05:48:39 2
|
a69106464 |
引用: 我给出的提示就是检测后出来的数据,瞎回答。。。
回复
2015-11-15 06:19:55 3
|
522240858 |
回复
2015-11-15 07:50:57 4
|
a69106464 |
回复
2015-11-15 10:56:18 5
|
诸葛御风 |
回复
2015-11-15 11:50:02 6
|
amysql |
Starting MySQL SUCCESS!
上面看mysql是有启动正常的。 是哪里提示Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)?
回复
2015-12-01 11:52:20 7
AMH面板 - 好用高效低占用、安全可靠极稳定 |