【军哥】修改mysql的my.cnf文件后 重启mysql报错

yangzhic

修改mysql的my.cnf文件后 重启mysql报错，请问怎么解决，网上的方法都试过了，不行，系统是linux centos

具体报错内容如下：

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 [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.
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:31  InnoDB: Waiting for the background threads to start
150423 18:19:32 InnoDB: 1.1.8 started; log sequence number 391498648
150423 18:19:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150423 18:19:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
150423 18:19:32 [Note] Server socket created on IP: '0.0.0.0'.
150423 18:19:32 [Note] Event Scheduler: Loaded 0 events
150423 18:19:32 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

licess

有个warning ，按提示 [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. 修改试试

yangzhic

意思是将原来的慢日志文件slow-query-log-file替换成slow-query-log？
改个文件名吗？
还是怎样？不太懂

licess

参数替换，不是文件名

hitxiong

原来的my.cnf 备份了么？ 先替换成不出错的my.cnf 文件。似乎是某个文件目录指向是错误的。

hitxiong

datadir = /usr/local/mysql/var  

似乎是这个，你看看。
你是不是用my-huge.cnf 替换my.cnf出的错。我上次也是直接替换出错了。后来回复成原来的my.cnf就没问题。

[ 本帖最后由 hitxiong 于 2015-4-25 19:28 编辑 ]