servers:mariadb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
servers:mariadb [2023/06/26 23:29] – Sean Rhone | servers:mariadb [2024/03/06 21:01] (current) – Sean Rhone | ||
---|---|---|---|
Line 3: | Line 3: | ||
* MariaDB ((https:// | * MariaDB ((https:// | ||
* [[Information: | * [[Information: | ||
+ | |||
+ | ===== References ===== | ||
+ | |||
+ | * https:// | ||
+ | * https:// | ||
===== Prerequisites ===== | ===== Prerequisites ===== | ||
Line 16: | Line 21: | ||
< | < | ||
[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=' | init-connect=' | ||
- | 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</ | + | table_definition_cache = '1400'</ |
==== Verify ===== | ==== Verify ===== | ||
Line 45: | Line 50: | ||
====== Initial Setup ====== | ====== Initial Setup ====== | ||
- | | + | **** |
- | sudo systemctl enable ' | + | sudo systemctl enable ' |
====== Database Repair and Optimization ====== | ====== Database Repair and Optimization ====== | ||
+ | |||
+ | * Not required for [[/ | ||
===== Create MySQL User ===== | ===== Create MySQL User ===== | ||
- | sudo mysql | + | sudo mariadb |
GRANT SELECT, INSERT ON *.* to ' | GRANT SELECT, INSERT ON *.* to ' | ||
Line 63: | Line 70: | ||
===== Authentication File ===== | ===== Authentication File ===== | ||
- | sudo mkdir -p '/ | + | sudo mkdir -p '/ |
< | < | ||
- | [mysqlcheck] | + | [mariadb-check] |
user=maintenance | user=maintenance | ||
password=x</ | password=x</ | ||
Line 79: | Line 86: | ||
Group=mysql | Group=mysql | ||
Type=oneshot | Type=oneshot | ||
- | ExecStart='/ | + | ExecStart='/ |
ExecStartPost='/ | ExecStartPost='/ | ||
/var/www/wiki/data/attic/servers/mariadb.1687836545.txt.gz · Last modified: 2023/06/26 23:29 by Sean Rhone