Install MySQL server yourself

Online help for LANMailServer

Email Server for Local Networks POP3 IMAP4 IMAP with Autoresponder, SMTP Relay Server, Email Distribution Groups, OAuth2 Support

Install MySQL server yourself

You can easily install a MySQL server on your own computer or any computer within your network. When using it with LANMailServer, it is recommended to install the database on the same computer to avoid delays caused by the network itself.

MySQL 8.0 or MariaDB 10.2 or newer is required. Older versions of MySQL/MariaDB cannot be used because SQL Window Functions are not supported by older versions.

For MySQL/MariaDB Experts

The latest MySQL server version can be found at https://dev.mysql.com/downloads/ or for MariaDB server at https://mariadb.org/. You must manage the configuration of the databases and database users yourself.

Example of manually creating a user named lanmailserver with the password lanmailserver_is_super, allowing access from all hosts.

CREATE USER 'lanmailserver'@'%' IDENTIFIED BY 'lanmailserver_is_super'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, SUPER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON *.* TO 'lanmailserver'@'%'; CREATE DATABASE IF NOT EXISTS `lanmailserver` CHARSET=utf8mb4; GRANT ALL PRIVILEGES ON `lanmailserver`.* TO 'lanmailserver'@'%';

Manual last updated: Fri, 4 Apr 2025 10:59:06 +0100

Manual as complete RSS feed: Manual as RSS feed

Manual localized with Microsoft Copilot

Erstellt mit RSSWriter https://www.rsswriter.de