mysql新建文件_定位及新建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/，如需转载，请注明出处，否则将追究法律责任。