servers:mariadb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
servers:mariadb [2022/07/20 13:25] – Sean Rhone | servers:mariadb [2023/09/12 17:21] – [Settings] Sean Rhone | ||
---|---|---|---|
Line 3: | Line 3: | ||
* MariaDB ((https:// | * MariaDB ((https:// | ||
* [[Information: | * [[Information: | ||
+ | |||
+ | ===== References ===== | ||
+ | |||
+ | * https:// | ||
+ | * https:// | ||
===== Prerequisites ===== | ===== Prerequisites ===== | ||
Line 18: | Line 23: | ||
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 | ||
Line 47: | Line 52: | ||
**** | **** | ||
- | sudo systemctl enable ' | + | sudo systemctl enable ' |
====== 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 ' | GRANT SELECT, INSERT ON *.* to ' | ||
Line 63: | Line 68: | ||
===== Authentication File ===== | ===== Authentication File ===== | ||
- | sudo mkdir -p '/ | + | sudo mkdir -p '/ |
< | < | ||
- | [mysqlcheck] | + | [mariadb-check] |
user=maintenance | user=maintenance | ||
password=x</ | password=x</ | ||
Line 79: | Line 84: | ||
Group=mysql | Group=mysql | ||
Type=oneshot | Type=oneshot | ||
- | ExecStart='/ | + | ExecStart='/ |
ExecStartPost='/ | ExecStartPost='/ | ||
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/06/11 10:28 by Sean Rhone