\documentclass{article}
\usepackage{ulem}
\usepackage{graphicx}
\usepackage{hyperref}
\pagestyle{headings}
\begin{document}
\part{SQL Database}
The Horde 6 Base application can be run without an SQL Database.
Most Horde 6 applications and features cannot be run without an SQL Database.
\section{MariaDB}
Horde 6 has been tested with MariaDB 10.8 and MariaDB 10.9 - any MariaDB of the 10.x series should work.
\begin{itemize}
\item ensure mariadb uses "innodb" as its default engine
\item ensure the PHP server can reach the database hostname and port
\item use utf8mb4 as default charset.
\item create a database schema. This documentation assumes the db name is "horde"
\end{itemize}
mysql> CREATE DATABASE horde;
\begin{itemize}
\item create a mariadb user with all default privileges on horde.*
\end{itemize}
mysql> create user 'hordeuser'@'\%' IDENTIFIED by 'hordepw';
mysql> GRANT ALL on horde.* to 'hordeuser'@'\%';
Do not use the default password shown here. If you run the DB on the same host as horde, use @'localhost' instead of @'\%'. If you want to restrict access to a specific IP address or network, consult the database manual.
\section{MySQL}
Horde 6 has been tested with MySQL 8 and MySQL 5.7 versions.
Use the "mysql" settings described under MariaDB.
\section{Percona Server}
Horde 6 has not been tested with Percona Server - any Percona 8 release should work.
Use the "mysql" settings described under MariaDB.
\section{SQLite}
TBD - untested for H6 except some libraries
\section{Postgresql}
TBD - Needs confirmation for H6
\#Create the database
sudo -u postgres psql horde
postgres=\# CREATE USER horde;
postgres=\# ALTER USER horde with password 'your password';
\#starting with postgres 15+
\$ sudo -u postgres psql
postgres=\# \textbackslash\{\}c horde
postgres=\# GRANT CREATE ON SCHEMA public TO horde;
\section{Oracle}
TBD - untested for H6
\end{document}