RoE | Wiki

User Tools

Site Tools

Trace:
servers:linux:mariadb

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
servers:linux:mariadb [2026/04/30 23:49] – [Service] Sean Rhoneservers:linux:mariadb [2026/10/24 05:51] (current) – Sean Rhone
Line 7: Line 7:
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]+  * [[linux:distros:server:arm:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
  
 ====== Settings ====== ====== Settings ======
Line 35: Line 35:
  
 ====== Dependencies ====== ====== Dependencies ======
- 
-**** 
  
   sudo zypper install 'mariadb'   sudo zypper install 'mariadb'
  
 ====== Initial Setup ====== ====== Initial Setup ======
- 
-  * Change the root password?: ''n'' 
  
   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
Line 49: Line 45:
  
 ===== One-shot ===== ===== One-shot =====
- 
-**** 
  
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
Line 118: Line 112:
  
 ===== Settings ===== ===== Settings =====
- 
-**** 
  
   sudo mariadb-admin variables | egrep 'utf8|networking|socket'   sudo mariadb-admin variables | egrep 'utf8|networking|socket'
  
 ===== Show Users on Server ===== ===== Show Users on Server =====
- 
-**** 
  
   select User,Host from mysql.user;   select User,Host from mysql.user;
  
 ===== Socket File ===== ===== Socket File =====
- 
-**** 
  
   /run/mysql/mysql.sock   /run/mysql/mysql.sock
/srv/www/wiki/data/pages/servers/linux/mariadb.txt · Last modified: by Sean Rhone