MariaDB—— 2.配置文件

vim /etc/my.cnf

[client]
port= 3306
socket= /tmp/mysql.sock

[mysqld]
port= 3306
socket= /tmp/mysql.sock
basedir=/usr/local/mysql #安装数据库目录）
datadir=/home/mydata #数据存放目录）
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin=mysql-bin
binlog_format=mixed
server-id= 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
user = root
password = 123456
host = 127.0.0.1

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

————Blueicex 2020/2/26 19:56 blueice1980@126.com