\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.<br />
Most Horde 6 applications and features cannot be run without an SQL Database.

\section{<a href="https://wiki.horde.org/MariaDB">MariaDB</a>}
Horde 6 has been tested with <a href="https://wiki.horde.org/MariaDB">MariaDB</a> 10.8 and <a href="https://wiki.horde.org/MariaDB">MariaDB</a> 10.9 - any <a href="https://wiki.horde.org/MariaDB">MariaDB</a> 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}
<pre><code>mysql> CREATE DATABASE horde;
</code></pre>
\begin{itemize}
\item create a mariadb user with all default privileges on horde.*


\end{itemize}
<pre><code>
mysql> create user 'hordeuser'@'\%' IDENTIFIED by 'hordepw';
mysql> GRANT ALL on horde.* to 'hordeuser'@'\%';
</code></pre>
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{<a href="https://wiki.horde.org/MySQL">MySQL</a>}
Horde 6 has been tested with <a href="https://wiki.horde.org/MySQL">MySQL</a> 8 and <a href="https://wiki.horde.org/MySQL">MySQL</a> 5.7 versions.<br />
Use the "mysql" settings described under <a href="https://wiki.horde.org/MariaDB">MariaDB</a>.

\section{Percona Server}
Horde 6 has not been tested with Percona Server - any Percona 8 release should work.<br />
Use the "mysql" settings described under <a href="https://wiki.horde.org/MariaDB">MariaDB</a>.

\section{SQLite}
TBD - untested for H6 except some libraries

\section{Postgresql}
TBD - Needs confirmation for H6

<pre><code>
\#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;
</code></pre>
\section{Oracle}
TBD - untested for H6

\end{document}
