User Tools

Site Tools


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
servers:mariadb [2023/09/12 17:19] Sean Rhoneservers:mariadb [2024/03/06 21:01] (current) Sean Rhone
Line 21: 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 55: Line 55:
  
 ====== Database Repair and Optimization ====== ====== Database Repair and Optimization ======
 +
 +  * Not required for [[/servers:games:trinitycore_3.3.5_localhost|TrinityCore 3.3.5 localhost]]
  
 ===== Create MySQL User ===== ===== Create MySQL User =====
/var/www/wiki/data/attic/servers/mariadb.1694553568.txt.gz · Last modified: 2023/09/12 17:19 by Sean Rhone