问题描述:
[root@bogon mysql-5.1.41]# /etc/rc.d/init.d/mysqld start
Starting MySQL.Manager of pid-file quit without updating file.[失败]
---------------------------
解决办法:
配置的时候有一个步骤是
cp support-files/my-medium.cnf /etc/my.cnf ;
就编辑my.cnf,在[mysqld]下面加上:datadir = /usr/local/mysql/data
例如
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-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
datadir = /usr/local/mysql/data
文章来自: 王殿臣-天空网(bestlovesky.com)详文参考:http://www.bestlovesky.com/read.php/27.htm