Differences

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

--- servers:bsd:mariadb [2024/10/03 02:51] – Sean Rhone
+++ servers:bsd:mariadb [2025/11/06 15:49] (current) – [Settings] Sean Rhone
@@ Line 1: / Line 1: @@
-====== Dependencies ======
+====== Information ======
-  * :!: 2024/10/03: ''mariadb114-server-11.4.2'' doesn't work ([[https://forums.freebsd.org/threads/mariadb-wont-start-automatically.73758/#post-674474|post]])
+  * MariaDB
+===== Prerequisites =====
+  * [[bsd:server:freebsd_15.0|FreeBSD 15.0]]
+====== Dependencies ======
-  su -l
+  su -
-  pkg install 'mariadb1011-server'
+  pkg install 'mariadb118-server'
 ====== Settings ======
-  su -l
+  * :?: TODO: Check ''skip-networking'' (it's commented)
+  su -
   ee '/usr/local/etc/mysql/conf.d/custom.cnf'
@@ Line 27: / Line 35: @@
 expire_logs_days = '7'
 max_binlog_size = '100M'
-skip-networking = 'On'
+#skip-networking = 'On'
-table_definition_cache = '1400'</code>
+table_definition_cache = '1400'
+# End</code>
 ====== Service ======
@@ Line 34: / Line 44: @@
 ===== Initial =====
-  su -l
+  su -
   sysrc mysql_enable="YES"
@@ Line 40: / Line 50: @@
   service 'mysql-server' start
-===== Troubleshooting =====
+===== Status =====
-  su -l
+  su -
   service 'mysql-server' status
-  /usr/local/etc/rc.d/mysql-server
 ====== Initial Setup ======
-  su -l
+  su -
   mariadb-secure-installation
 ====== Optimize ======
-****
   mariadb-check -u 'root' -p -o -A -f -e --auto-repair
+  mariadb-check -o -A -f -e --auto-repair
 ====== Other ======
@@ Line 64: / Line 72: @@
 ===== Binaries =====
-  pkg info -l 'mariadb1011-server' | grep 'bin'
+  pkg info -l 'mariadb118-server' | grep 'bin'
-  pkg info -l 'mariadb1011-client' | grep 'bin'
+  pkg info -l 'mariadb118-client' | grep 'bin'
 ===== Settings Query =====