====== Information ======

  * MariaDB ((https://mariadb.org/))
  * Server
  * [[information:realm_of_espionage|Realm of Espionage]]

===== Prerequisites =====

  * [[bsd:server:freebsd_16.0|FreeBSD 16.0]]

====== Dependencies ======

  su -

  pkg install 'mariadb118-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 = 'Off'
table_definition_cache = '1400'

# End</code>

====== Service ======

===== Initial =====

  su -

  sysrc mysql_enable="YES"

  service 'mysql-server' start

===== Status =====

  su -

  service 'mysql-server' status

====== Initial Setup ======

  su -

  mariadb-secure-installation

====== Database Repair and Optimization ======

===== One-shot =====

  su -

  mariadb-check -o -A -f -e --auto-repair

===== cron =====

==== Script ====

  mkdir -p ~/'.local/scripts/mariadb' && ee ~/'.local/scripts/mariadb/optimize.sh' && chmod +x ~/'.local/scripts/mariadb/optimize.sh'

<code>
#!/bin/sh

'/usr/local/bin/mariadb-check' -o -A -f -e --auto-repair > '/dev/null'

'/bin/sync'

# End</code>

  su 'root' -c ~/'.local/scripts/mariadb/optimize.sh'

==== cron ====

  * Weekly (Sunday) ''07:10:00 AM''

  su -

  ee '/etc/cron.d/mariadb-optimize'

<code>
#
SHELL=/bin/sh

10 7 * * sun root '/home/espionage724/.local/scripts/mariadb/optimize.sh'

# End</code>

====== Notable Commands ======

===== Binaries =====

  pkg info -l 'mariadb118-server' | grep 'bin'

  pkg info -l 'mariadb118-client' | grep 'bin'

===== Settings =====

  su -

  mariadb-admin variables | egrep 'utf8|networking|socket'

===== Show Users on Server =====

  su -

  mariadb

  select User,Host from mysql.user;