mysql启动失败quit without updating fi[FAILED
[i=s] 本帖最后由 jiang9878 于 2012-8-25 11:55 编辑 [/i][root@localhost ~]# sed -i '/skip-innodb/d' /www/wdlinux/etc/my.cnf
[root@localhost ~]# service mysqld restart
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
centos5.6 64位 安装一键包RPM 安装完后修改了mysql的 root密码 不能创建数据库用户,提示原始密码错,使用工具检查mysql权限后,正常,然后修改mysql 配置 保存 重启就不行了。[code]# mysql conf /etc/my.cnf
# Created by http://www.wdlinux.cn
# Last Updated 2010.06.01
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 4M
table_open_cache = 512
sort_buffer_size = 6M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 64
query_cache_size= 64M
thread_concurrency = 8
max_connections = 512
wait_timeout = 10
interactive_timeout = 30
max_connect_errors = 30
long_query_time = 1
tmp_table_size = 16M
#log-bin=mysql-bin
#binlog_format=mixed
#server-id = 1
[mysqldump]
quick
max_allowed_packet = 8M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 12M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
[/code]按照论坛的其他类似修复方法都失效。请管理员帮忙检查下是什么错误。
补充:使用 sh /www/wdlinux/tools/mysql_root_chg.sh 重置密码后,自动默认启动状态。怎么解决可以 正常重启mysql服务 [b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=12551&ptid=3373]1#[/url] [i]jiang9878[/i] [/b]
/www/wdlinux/init.d/mysqld 这个是相关启动重启mysql配置文件,检测一下有没有给予执行权限,设置是否有误 [b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=12554&ptid=3373]2#[/url] [i]qqcm[/i] [/b]
估计是权限问题,我卸载重装rpm 就好了。 chown -R mysql.mysql .
页:
[1]