User Tools

Site Tools


servers:bsd:mariadb

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
servers:bsd:mariadb [2024/10/03 02:51] Sean Rhoneservers:bsd:mariadb [2025/05/16 23:38] (current) Sean Rhone
Line 1: Line 1:
 ====== Dependencies ====== ====== 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 -
  
-  su -l +  pkg install 'mariadb114-server'
- +
-  pkg install 'mariadb1011-server'+
  
 ====== Settings ====== ====== Settings ======
  
-  su -l+  su -
  
   ee '/usr/local/etc/mysql/conf.d/custom.cnf'   ee '/usr/local/etc/mysql/conf.d/custom.cnf'
Line 27: Line 25:
 expire_logs_days = '7' expire_logs_days = '7'
 max_binlog_size = '100M' max_binlog_size = '100M'
-skip-networking = 'On' +#skip-networking = 'On' 
-table_definition_cache = '1400'</code>+table_definition_cache = '1400' 
 + 
 +# End</code>
  
 ====== Service ====== ====== Service ======
Line 34: Line 34:
 ===== Initial ===== ===== Initial =====
  
-  su -l+  su -
  
   sysrc mysql_enable="YES"   sysrc mysql_enable="YES"
Line 40: Line 40:
   service 'mysql-server' start   service 'mysql-server' start
  
-===== Troubleshooting =====+===== Status =====
  
-  su -l+  su -
  
   service 'mysql-server' status   service 'mysql-server' status
- 
-  /usr/local/etc/rc.d/mysql-server 
  
 ====== Initial Setup ====== ====== Initial Setup ======
  
-  su -l+  su -
  
   mariadb-secure-installation   mariadb-secure-installation
Line 64: Line 62:
 ===== Binaries ===== ===== Binaries =====
  
-  pkg info -l 'mariadb1011-server' | grep 'bin'+  pkg info -l 'mariadb114-server' | grep 'bin'
  
-  pkg info -l 'mariadb1011-client' | grep 'bin'+  pkg info -l 'mariadb114-client' | grep 'bin'
  
 ===== Settings Query ===== ===== Settings Query =====
/srv/www/wiki/data/attic/servers/bsd/mariadb.1727938268.txt.gz · Last modified: by Sean Rhone