• MariaDB

• FreeBSD 15.0

su -

pkg install 'mariadb118-server'

su -

ee '/usr/local/etc/mysql/conf.d/custom.cnf'

[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'

# End

su -

sysrc mysql_enable="YES"

service 'mysql-server' start

su -

service 'mysql-server' status

su -

mariadb-secure-installation

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

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

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

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

mariadb-admin -u 'root' -p variables | egrep 'utf8|networking|socket'

mariadb-admin variables -u 'root' -p | grep 'socket'

/var/run/mysql/mysql.sock