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/14 11:29] – Fedora 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:fedora_workstation_gnome#server|Fedora]]+  * [[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 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 63: Line 68:
 ===== Authentication File ===== ===== Authentication File =====
  
-  sudo mkdir -p '/var/lib/mysql/auth' && sudo chown -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo -u 'mysql' -e '/var/lib/mysql/auth/maintenance' && sudo chmod '600' '/var/lib/mysql/auth/maintenance'+  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo chmod '600' '/var/lib/mysql/auth/maintenance' && sync
  
 <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>
  
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone