AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] 数据库启动不了,怎么解决啊 |
|
---|---|
ggppc |
ggppc 发表于 2014-11-07 10:01:30
[AMH] MySQL Management please select: (1~6) 1) start 3) restart 5) force-reload 2) stop 4) reload 6) exit #? 3 ERROR! MySQL server PID file could not be found! Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_197_175_centos.pid). [root@VM_197_175_centos ~]#
点赞,加油! (0分)
2014-11-07 10:01:30 1
|
ggppc |
[Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Mysql链接出错,请配置/Amysql/config.php文件。#
回复
2014-11-07 10:11:29 2
|
amysql |
是4.2吗
检查下这几项: 磁盘是否有空间 数据库目录是否有权限 my.conf配置是否正确与是否有重复的情况 都排查一下。
回复
2014-11-07 10:16:03 3
AMH面板 - 好用高效低占用、安全可靠极稳定 |
ggppc |
回复
2014-11-07 10:37:50 4
|
ggppc |
my conf 文件的内容 [client] port = 3306 socket = /tmp/mysql.sock [mysqld] default-storage-engine = MyISAM innodb = OFF skip-innodb port = 3306 socket = /tmp/mysql.sock 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 [mysqldump] quick [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
回复
2014-11-07 10:51:19 5
|
ggppc |
回复
2014-11-07 10:51:50 6
|
ggppc |
启动数据库就提示这个
[root@VM_197_175_centos ~]# amh mysql ============================================================= [LNMP/Nginx] Amysql Host - AMH 4.2 http://Amysql.com [AMH] MySQL Management please select: (1~6) 1) start 3) restart 5) force-reload 2) stop 4) reload 6) exit #? 1 Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_197_175_centos.pid). [root@VM_197_175_centos ~]#
回复
2014-11-07 10:55:38 7
|
amysql |
已经解决。磁盘没空间的原因。
回复
2014-11-07 11:11:15 8
|