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

  * :!: 2024/10/03: ''mariadb114-server-11.4.2'' doesn't work ([[https://forums.freebsd.org/threads/mariadb-wont-start-automatically.73758/#post-674474|post]])

  su -l

  pkg install 'mariadb1011-server'

====== Settings ======

  su -l

  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 -l

  sysrc mysql_enable="YES"

  service 'mysql-server' start

===== Troubleshooting =====

  su -l

  service 'mysql-server' status

  /usr/local/etc/rc.d/mysql-server

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

  su -l

  mariadb-secure-installation

====== Optimize ======

****

  mariadb-check -u 'root' -p -o -A -f -e --auto-repair

====== Other ======

===== Binaries =====

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

  pkg info -l 'mariadb1011-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