Differences

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

--- servers:bsd:mariadb [2024/10/03 01:29] – Sean Rhone
+++ servers:bsd:mariadb [2025/11/06 15:49] (current) – [Settings] Sean Rhone
@@ Line 1: / Line 1: @@
+====== Information ======
+  * MariaDB
+===== Prerequisites =====
+  * [[bsd:server:freebsd_15.0|FreeBSD 15.0]]
+====== Dependencies ======
+  su -
+  pkg install 'mariadb118-server'
 ====== Settings ======
+  * :?: TODO: Check ''skip-networking'' (it's commented)
+  su -
   ee '/usr/local/etc/mysql/conf.d/custom.cnf'
@@ Line 17: / 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>
-  * TODO (copy of mysql)
+====== Service ======
-<code>
+===== Initial =====
-root@Spinesnap:~ # service 'mysql-server' start
-Installing MariaDB/MySQL system tables in '/var/db/mysql' ...
-OK
-To start mariadbd at boot time you have to copy
+  su -
-support-files/mariadb.service to the right place for your system
+  sysrc mysql_enable="YES"
-Two all-privilege accounts were created.
+  service 'mysql-server' start
-One is root@localhost, it has no password, but you need to
-be system 'root' user to connect. Use, for example, sudo mysql
-The second is root@localhost, it has no password either, but
-you need to be the system 'root' user to connect.
-After connecting you can set the password, if you would need to be
-able to connect as any of these users with a password and without sudo
-See the MariaDB Knowledgebase at https://mariadb.com/kb
+===== Status =====
-You can start the MariaDB daemon with:
+  su -
-cd '/usr/local' ; /usr/local/bin/mariadbd-safe --datadir='/var/db/mysql'
-You can test the MariaDB daemon with mariadb-test-run.pl
+  service 'mysql-server' status
-cd '/usr/local/' ; perl mariadb-test-run.pl
-Please report any problems at https://mariadb.org/jira
+====== Initial Setup ======
-The latest information about MariaDB is available at https://mariadb.org/.
+  su -
-Consider joining MariaDB's strong and vibrant community:
+  mariadb-secure-installation
-https://mariadb.org/get-involved/
-Starting mysql.
+====== Optimize ======
-</code>
-  service 'mysql-server' status
+  mariadb-check -u 'root' -p -o -A -f -e --auto-repair
-  sysrc mysql_enable="YES"
+  mariadb-check -o -A -f -e --auto-repair
-  service 'mysql-server' start
+====== Other ======
-  mysql_secure_installation
+===== Binaries =====
-  mysqladmin
+  pkg info -l 'mariadb118-server' | grep 'bin'
-  mysqlcheck -u 'root' -p -o -A -f -e --auto-repair
+  pkg info -l 'mariadb118-client' | grep 'bin'
-  mysqladmin -u 'root' -p variables | egrep 'utf8|networking|socket'
+===== Settings Query =====
-  /tmp/mysql.sock
+****
-  /tmp/mysqlx.sock
+  mariadb-admin -u 'root' -p variables | egrep 'utf8|networking|socket'
-====== Install Notes ======
+===== Socket =====
-<code>
-=====
-Message from mariadb114-server-11.4.2:
---
+  mariadb-admin variables -u 'root' -p | grep 'socket'
-MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for
-my.cnf. Please move existing my.cnf files from those paths to
-/usr/local/etc/mysql or /usr/local/etc. Sample
-configuration files are provided in /usr/local/etc/mysql
-and /usr/local/etc/mysql/conf.d.
-The rc(8) script no longer uses /var/db/mysql/my.cnf for configuration
-nor /var/db/mysql for logs and PID-file.
-This port does NOT include the mytop perl script, this is included in
+  /var/run/mysql/mysql.sock
-the MariaDB tarball but the most recent version can be found in the
-databases/mytop port
-Using wsrep clustering requires adding a configuration file.
-Copy /usr/local/etc/mysql/conf.d/wsrep.conf.sample to
-/usr/local/etc/mysql/conf.d/wsrep.conf and change what you need there.
-</code>