Sign Up
Log In
Log In
or
Sign Up
Places
All Projects
Status Monitor
Collapse sidebar
openSUSE:Factory:Rings:1-MinimalX
mariadb
my.ini
Overview
Repositories
Revisions
Requests
Users
Attributes
Meta
File my.ini of Package mariadb
# The following options will be passed to all MariaDB clients [client] # Please note that storing the password in this file is not safe. For this # purpose you can, for example, list your password in the [client] section # of the '~/.my.cnf' configuration file with an access mode set to 400 or 600. # password = your_password # port = 3306 # socket = /run/mysql/mysql.sock # The MariaDB server [mysqld] # For security reasons, bind to 127.0.0.1 by default to enable networking # only on the loopback interface. bind-address = 127.0.0.1 # If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err" # which is not beneficial for rotating the log file if it grows in size. log-error = /var/log/mysql/mysqld.log # Enable the slow query log to see queries with especially long duration # slow_query_log=1 # slow_query_log_file = /var/log/mysql/mysqld_slow.log # Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only # work with files in the specified directory secure_file_priv = /var/lib/mysql-files # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin=mysql-bin # binlog_format=mixed # Remove leading # if you want to store your database elsewhere # datadir = /var/lib/mysql # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # These are commonly set, remove the # and set as required. # port = 3306 # socket = /run/mysql/mysql.sock # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # Configure the MariaDB server to use SSL # ssl-ca=/etc/mysql/ssl/ca-cert.pem # ssl-cert=/etc/mysql/ssl/server-cert.pem # ssl-key=/etc/mysql/ssl/server-key.pem [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log = /var/log/mysqld_multi.log # If you want to use mysqld_multi uncomment 1 or more mysqld sections # below or add your own ones. # WARNING # -------- # If you uncomment mysqld1 than make absolutely sure, that database mysql, # configured above, is not started. This may result in corrupted data! # # [mysqld1] # port = 3306 # datadir = /var/lib/mysql # pid-file = /var/lib/mysql/mysqld.pid # socket = /var/lib/mysql/mysql.sock # user = mysql # [mysqld2] # port = 3307 # datadir = /var/lib/mysql-databases/mysqld2 # pid-file = /var/lib/mysql-databases/mysqld2/mysql.pid # socket = /var/lib/mysql-databases/mysqld2/mysql.sock # user = mysql # [mysqld3] # port = 3308 # datadir = /var/lib/mysql-databases/mysqld3 # pid-file = /var/lib/mysql-databases/mysqld3/mysql.pid # socket = /var/lib/mysql-databases/mysqld3/mysql.sock # user = mysql # [mysqld6] # port = 3309 # datadir = /var/lib/mysql-databases/mysqld6 # pid-file = /var/lib/mysql-databases/mysqld6/mysql.pid # socket = /var/lib/mysql-databases/mysqld6/mysql.sock # user = mysql !includedir /etc/my.cnf.d
Locations
Projects
Search
Status Monitor
Help
OpenBuildService.org
Documentation
API Documentation
Code of Conduct
Contact
Support
@OBShq
Terms
openSUSE Build Service is sponsored by
The Open Build Service is an
openSUSE project
.
Sign Up
Log In
Places
Places
All Projects
Status Monitor