RoE | Wiki

User Tools

Site Tools

Trace:
servers: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
Last revisionBoth sides next revision
servers:mariadb [2021/06/18 17:22] – openSUSE TW Sean Rhoneservers:mariadb [2023/09/12 17:25] – [Settings] Sean Rhone
Line 3: Line 3:
   * MariaDB ((https://mariadb.org/about))   * MariaDB ((https://mariadb.org/about))
   * [[Information:Realm of Espionage]]   * [[Information:Realm of Espionage]]
 +
 +===== References =====
 +
 +  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
 +  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:opensuse_tumbleweed_server|openSUSE Tumbleweed]]+  * [[distros:fedora_server|Fedora Server]]
  
 ====== Settings ====== ====== Settings ======
Line 16: Line 21:
 <code> <code>
 [client] [client]
-default-character-set = utf8mb4+default-character-set = 'utf8mb4'
  
-[mysql] +[mariadb-client] 
-default-character-set = utf8mb4+default-character-set = 'utf8mb4'
  
-[mysqld] +[mariadbd] 
-character-set-client-handshake = FALSE +character-set-client-handshake = 'FALSE' 
-character-set-server = utf8mb4 +character-set-server = 'utf8mb4' 
-collation-server = utf8mb4_unicode_ci+collation-server = 'utf8mb4_unicode_ci'
 init-connect='SET NAMES utf8mb4' init-connect='SET NAMES utf8mb4'
-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'</code>
  
 ==== Verify ===== ==== Verify =====
Line 41: Line 46:
 **** ****
  
-  sudo zypper install 'mariadb'+  sudo dnf install 'mariadb-server'
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 47: Line 52:
 **** ****
  
-  sudo systemctl enable 'mariadb' --now && sudo mysql_secure_installation+  sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
  
 ====== Database Repair and Optimization ====== ====== Database Repair and Optimization ======
Line 53: Line 58:
 ===== Create MySQL User ===== ===== Create MySQL User =====
  
-  sudo mysql+  sudo mariadb
  
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';
Line 66: Line 71:
  
 <code> <code>
-[mysqlcheck]+[mariadb-check]
 user=maintenance user=maintenance
 password=x</code> password=x</code>
Line 79: Line 84:
 Group=mysql Group=mysql
 Type=oneshot Type=oneshot
-ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force+ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force
 ExecStartPost='/usr/bin/sync'</code> ExecStartPost='/usr/bin/sync'</code>
  
Line 110: Line 115:
 **** ****
  
-  /run/mysql/mysql.sock+  /var/lib/mysql/mysql.sock
  
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone