No4NaMe

Untitled

Mar 28th, 2021
487
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #
  2. # These groups are read by MariaDB server.
  3. # Use it for options that only the server (but not clients) should see
  4. #
  5. # See the examples of server my.cnf files in /usr/share/mysql
  6.  
  7. # this is read by the standalone daemon and embedded servers
  8. [server]
  9.  
  10. # this is only for the mysqld standalone daemon
  11. [mysqld]
  12.  
  13. #
  14. # * Basic Settings
  15. #
  16. user                    = mysql
  17. pid-file                = /run/mysqld/mysqld.pid
  18. socket                  = /run/mysqld/mysqld.sock
  19. #port                   = 3306
  20. basedir                 = /usr
  21. datadir                 = /var/lib/mysql
  22. tmpdir                  = /tmp
  23. lc-messages-dir         = /usr/share/mysql
  24. #skip-external-locking
  25.  
  26. # Instead of skip-networking the default is now to listen only on
  27. # localhost which is more compatible and is not less secure.
  28. bind-address            = 0.0.0.0
  29.  
  30. #
  31. # * Fine Tuning
  32. #
  33. #key_buffer_size        = 16M
  34. #max_allowed_packet     = 16M
  35. #thread_stack           = 192K
  36. #thread_cache_size      = 8
  37. # This replaces the startup script and checks MyISAM tables if needed
  38. # the first time they are touched
  39. #myisam_recover_options = BACKUP
  40. #max_connections        = 100
  41. #table_cache            = 64
  42. #thread_concurrency     = 10
  43.  
  44. #
  45. # * Query Cache Configuration
  46. #
  47. #query_cache_limit      = 1M
  48. query_cache_size        = 16M
  49.  
  50. #
  51. # * Logging and Replication
  52. #
  53. # Both location gets rotated by the cronjob.
  54. # Be aware that this log type is a performance killer.
  55. # As of 5.1 you can enable the log at runtime!
  56. #general_log_file       = /var/log/mysql/mysql.log
  57. #general_log            = 1
  58. #
  59. # Error log - should be very few entries.
  60. #
  61. log_error = /var/log/mysql/error.log
  62. #
  63. # Enable the slow query log to see queries with especially long duration
  64. #slow_query_log_file    = /var/log/mysql/mariadb-slow.log
  65. #long_query_time        = 10
  66. #log_slow_rate_limit    = 1000
  67. #log_slow_verbosity     = query_plan
  68. #log-queries-not-using-indexes
  69. #
  70. # The following can be used as easy to replay backup logs or for replication.
  71. # note: if you are setting up a replication slave, see README.Debian about
  72. #       other settings you may need to change.
  73. #server-id              = 1
  74. #log_bin                = /var/log/mysql/mysql-bin.log
  75. expire_logs_days        = 10
  76. #max_binlog_size        = 100M
  77. #binlog_do_db           = include_database_name
  78. #binlog_ignore_db       = exclude_database_name
  79.  
  80. #
  81. # * Security Features
  82. #
  83. # Read the manual, too, if you want chroot!
  84. #chroot = /var/lib/mysql/
  85. #
  86. # For generating SSL certificates you can use for example the GUI tool "tinyca".
  87. #
  88. #ssl-ca = /etc/mysql/cacert.pem
  89. #ssl-cert = /etc/mysql/server-cert.pem
  90. #ssl-key = /etc/mysql/server-key.pem
  91. #
  92. # Accept only connections using the latest and most secure TLS protocol version.
  93. # ..when MariaDB is compiled with OpenSSL:
  94. #ssl-cipher = TLSv1.2
  95. # ..when MariaDB is compiled with YaSSL (default in Debian):
  96. #ssl = on
  97.  
  98. #
  99. # * Character sets
  100. #
  101. # MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
  102. # utf8 4-byte character set. See also client.cnf
  103. #
  104. character-set-server  = utf8mb4
  105. collation-server      = utf8mb4_general_ci
  106.  
  107. #
  108. # * InnoDB
  109. #
  110. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  111. # Read the manual for more InnoDB related options. There are many!
  112.  
  113. #
  114. # * Unix socket authentication plugin is built-in since 10.0.22-6
  115. #
  116. # Needed so the root database user can authenticate without a password but
  117. # only when running as the unix root user.
  118. #
  119. # Also available for other users if required.
  120. # See https://mariadb.com/kb/en/unix_socket-authentication-plugin/
  121.  
  122. # this is only for embedded server
  123. [embedded]
  124.  
  125. # This group is only read by MariaDB servers, not by MySQL.
  126. # If you use the same .cnf file for MySQL and MariaDB,
  127. # you can put MariaDB-only options here
  128. [mariadb]
  129.  
  130. # This group is only read by MariaDB-10.3 servers.
  131. # If you use the same .cnf file for MariaDB of different versions,
  132. # use this group for options that older servers don't understand
  133. [mariadb-10.3]
  134.  
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×