定位及新建mysql的参数文件

laojiang:~/mysql_setup # mysql --help | grep my.cnf
                      order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf 
laojiang:~/mysql_setup # 
laojiang:~ # ps -efa |grep mysql
root     21722     1  0 08:34 pts/3    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql/ --pid-file=/var/lib/mysql/laojiang.pid
mysql    22227 21722  1 08:34 pts/3    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/laojiang.err --pid-file=/var/lib/mysql/laojiang.pid --socket=/var/lib/mysql/mysql.sock --port=3307
root     22278 28068  0 08:35 pts/1    00:00:00 grep mysql
root     29575 28768  0 08:11 pts/2    00:00:00 mysql -uroot -px xx
会发现所有目录没有my.cnf，但mysql同样可以启动，然后在/etc下新建my.cnf文件。
laojiang:/etc # cat my.cnf 
[mysqld]
long_query_time=1
slow_query_log=ON
slow_query_log_file=/var/lib/mysql/mysql-slow_2.log
character-set-server=utf8
collation_server=utf8_bin
key_buffer_size = 8M
max_allowed_packet = 4M
table_open_cache = 2000
sort_buffer_size = 256K
read_buffer_size = 128K
read_rnd_buffer_size = 256K
thread_cache_size = 0
query_cache_type=0
query_cache_size = 0
myisam_sort_buffer_size = 8M
innodb_buffer_pool_size = 600M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb-open-files = 300
innodb_log_file_size = 100M
innodb_log_files_in_group=2
skip-external-locking
explicit_defaults_for_timestamp
innodb-file-per-table
skip-show-database = 1
max_connect_errors = 100000
#innodb_data_file_path = ibdata1:500M:autoextend
#sysdate-is-now
bind_address = 10.10.10.212
port     = 3307
socket   =  /var/lib/mysql/mysql.sock
datadir  = /var/lib/mysql/
#innodb_data_home_dir =  
#innodb_log_group_home_dir = ./
log-error=/var/lib/mysql/laojiang.err
pid-file=/var/lib/mysql/laojiang.pid
[client]
port            = 3307
socket          = /var/lib/mysql/mysql.sock
default-character-set=utf8


若上面参数innodb_data_file_path innodb_data_home_dir innodb_log_group_home_dir设置变更，则可能启动不了，出现如下错误：
laojiang:/var/lib/mysql # service mysql start
Starting MySQL.The server quit without updating PID file (/var/lib/mysql//laojiang.pid).    

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29911917/viewspace-1280877/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29911917/viewspace-1280877/