Differences

This shows you the differences between two versions of the page.

--- servers:bsd:mariadb [2024/09/15 19:50] – Nope; MariaDB pulls in libfmt which breaks TC 3.3.5 compiling; MySQL is fine Sean Rhone
+++ servers:bsd:mariadb [2024/12/01 14:28] (current) – Sean Rhone
@@ Line 1: / Line 1: @@
+====== Dependencies ======
+  su -
+  pkg install 'mariadb114-server'
+====== Settings ======
+  su -
+  ee '/usr/local/etc/mysql/conf.d/custom.cnf'
+<code>
+[client]
+default-character-set = 'utf8mb4'
+[mariadb-client]
+default-character-set = 'utf8mb4'
+[mariadbd]
+character-set-client-handshake = 'FALSE'
+character-set-server = 'utf8mb4'
+collation-server = 'utf8mb4_unicode_ci'
+init-connect='SET NAMES utf8mb4'
+expire_logs_days = '7'
+max_binlog_size = '100M'
+skip-networking = 'On'
+table_definition_cache = '1400'</code>
+====== Service ======
+===== Initial =====
+  su -
+  sysrc mysql_enable="YES"
+  service 'mysql-server' start
+===== Status =====
+  su -
+  service 'mysql-server' status
+====== Initial Setup ======
+  su -
+  mariadb-secure-installation
+====== Optimize ======
+****
+  mariadb-check -u 'root' -p -o -A -f -e --auto-repair
+====== Other ======
+===== Binaries =====
+  pkg info -l 'mariadb114-server' | grep 'bin'
+  pkg info -l 'mariadb114-client' | grep 'bin'
+===== Settings Query =====
+****
+  mariadb-admin -u 'root' -p variables | egrep 'utf8|networking|socket'
+===== Socket =====
+  mariadb-admin variables -u 'root' -p | grep 'socket'
+  /var/run/mysql/mysql.sock