Differences

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

--- servers:bsd:mariadb [2024/10/01 22:07] – created Sean Rhone
+++ servers:bsd:mariadb [2024/12/01 14:28] (current) – Sean Rhone
@@ Line 1: / Line 1: @@
+====== Dependencies ======
-  * TODO (copy of mysql)
+  su -
+  pkg install 'mariadb114-server'
+====== Settings ======
+  su -
+  ee '/usr/local/etc/mysql/conf.d/custom.cnf'
 <code>
-Checking integrity... done (0 conflicting)
+[client]
-[1/1] Installing mysql84-server-8.4.0...
+default-character-set = 'utf8mb4'
-===> Creating groups
-Using existing group 'mysql'
-===> Creating users
-Using existing user 'mysql'
-===> Creating homedir(s)
-[1/1] Extracting mysql84-server-8.4.0: 100%
-=====
-Message from mysql84-server-8.4.0:
---
+[mariadb-client]
-There is no initial password for first time use of MySQL.
+default-character-set = 'utf8mb4'
-Keep in mind to reset it to a secure password.
-MySQL 8.4 has a default /usr/local/etc/mysql/my.cnf,
+[mariadbd]
-remember to replace it with your own
+character-set-client-handshake = 'FALSE'
-or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
+character-set-server = 'utf8mb4'
-</code>
+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 'mysql-server' status
+====== Service ======
+===== Initial =====
+  su -
   sysrc mysql_enable="YES"
@@ Line 29: / Line 38: @@
   service 'mysql-server' start
-  mysql_secure_installation
+===== 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 =====
-  mysqladmin
+****
-  mysqlcheck -u 'root' -p -o -A -f -e --auto-repair
+  mariadb-admin -u 'root' -p variables | egrep 'utf8|networking|socket'
-  mysqladmin -u 'root' -p variables | egrep 'utf8|networking|socket'
+===== Socket =====
-  /tmp/mysql.sock
+  mariadb-admin variables -u 'root' -p | grep 'socket'
-  /tmp/mysqlx.sock
+  /var/run/mysql/mysql.sock