Difference between revisions of "/etc/mysql/mariadb.conf.d/50-server.cnf"

From wikieduonline
Jump to navigation Jump to search
(Created page with "<pre> cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep . [server] [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld...")
Tags: Mobile web edit, Mobile edit
 
Tags: Mobile web edit, Mobile edit
Line 8: Line 8:
 
port = 3306
 
port = 3306
 
basedir = /usr
 
basedir = /usr
datadir = /var/lib/mysql
+
datadir = [[/var/lib/]]mysql
 
tmpdir = /tmp
 
tmpdir = /tmp
 
lc-messages-dir = /usr/share/mysql
 
lc-messages-dir = /usr/share/mysql

Revision as of 17:31, 27 May 2020

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep .
[server]
[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= [[/var/lib/]]mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
bind-address		= 127.0.0.1
key_buffer_size		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
myisam_recover_options  = BACKUP
query_cache_limit	= 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days	= 10
max_binlog_size   = 100M
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
[embedded]
[mariadb]
[mariadb-10.1]

See also

Advertising: