Chinaunix

标题: mysql启动不起来了(请高手看一下) [打印本页]

作者: zhubowen_636 时间: 2008-09-08 12:55
标题: mysql启动不起来了(请高手看一下)
/usr/local/mysql/bin/mysqld_safe --user=mysql -pxxxxxx&
lve &
[1] 28575
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/localhost.pid
080908 12:15:31  mysqld ended

err 日志如下
080908 12:15:31  mysqld started
080908 12:15:31 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-name-resovle'

080908 12:15:31  mysqld ended
请问如何能够重新启动mysql 　--skip-name-resovle 是什么选项啊

作者: denniswwh 时间: 2008-09-08 14:32
标题: 回复 #1 zhubowen_636 的帖子
单词拼错了嘛，应该是 skip-name-resolve

作者: ruochen 时间: 2008-09-08 14:46

原帖由 denniswwh 于 2008-9-8 14:32 发表
单词拼错了嘛，应该是 skip-name-resolve

hoho

作者: zhubowen_636 时间: 2008-09-08 15:22

原帖由 denniswwh 于 2008-9-8 14:32 发表
单词拼错了嘛，应该是 skip-name-resolve

谢谢问题出的地方我知道了。但是我这边根本没有在启动里面加这些参数。我的mysql.cn
[mysqld]
port          = 3306
socket       = /tmp/mysql.sock
skip-locking
key_buffer = 460M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 8M
read_buffer_size = 4M
read_rnd_buffer_size = 12M
myisam_sort_buffer_size = 120M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

max_connections=2000
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
#server-id    = 1
--More--

里面没有设置类似的配置，这边接收不长。服务器不是我配置的。我想请问一下还有其他的地方可以加这个参数吗。
另外补充一下我当时由于mysql的root密码忘记，把mysql进程杀死后就出现类似问题

作者: denniswwh 时间: 2008-09-08 16:36
标题: 回复 #4 zhubowen_636 的帖子
在my.cnf里应该有的，你找找看，估计是哪个家伙加了这个参数一直没重启过，你一重启加载了这个参数就出错了

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)