【军哥】修改mysql的my.cnf文件后 重启mysql报错
修改mysql的my.cnf文件后 重启mysql报错，请问怎么解决，网上的方法都试过了，不行，系统是linux centos :Q:Q具体报错内容如下：
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/AY14022110414457959eZ.pid).
下面是mysql的错误日志
150423 18:19:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
150423 18:19:31 The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
150423 18:19:31 InnoDB: The InnoDB memory heap is disabled
150423 18:19:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150423 18:19:31 InnoDB: Compressed tables use zlib 1.2.3
150423 18:19:31 InnoDB: Initializing buffer pool, size = 16.0M
150423 18:19:31 InnoDB: Completed initialization of buffer pool
150423 18:19:31 InnoDB: highest supported file format is Barracuda.
150423 18:19:31InnoDB: Waiting for the background threads to start
150423 18:19:32 InnoDB: 1.1.8 started; log sequence number 391498648
150423 18:19:32 Server hostname (bind-address): '0.0.0.0'; port: 3306
150423 18:19:32 - '0.0.0.0' resolves to '0.0.0.0';
150423 18:19:32 Server socket created on IP: '0.0.0.0'.
150423 18:19:32 Event Scheduler: Loaded 0 events
150423 18:19:32 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log'socket: '/tmp/mysql.sock'port: 3306Source distribution 有个warning ，按提示 The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 修改试试
回复 2# 的帖子
意思是将原来的慢日志文件slow-query-log-file替换成slow-query-log？改个文件名吗？
还是怎样？不太懂 参数替换，不是文件名 原来的my.cnf 备份了么？ 先替换成不出错的my.cnf 文件。似乎是某个文件目录指向是错误的。 datadir = /usr/local/mysql/var
似乎是这个，你看看。
你是不是用my-huge.cnf 替换my.cnf出的错。我上次也是直接替换出错了。后来回复成原来的my.cnf就没问题。
[ 本帖最后由 hitxiong 于 2015-4-25 19:28 编辑 ]
页:
[1]