MariaDB - Revision history

John3-16: Section added: /* TLS/SSL Configuration */ re workaround currently required with new TLS validation behaviour

2026-01-01T00:59:41Z

Section added: TLS/SSL Configuration: re workaround currently required with new TLS validation behaviour

← Older revision		Revision as of 00:59, 1 January 2026
Line 112:		Line 112:
	sed -i "s\|.skip-networking.\|skip-networking\|g" /etc/my.cnf.d/mariadb-server.cnf		sed -i "s\|.skip-networking.\|skip-networking\|g" /etc/my.cnf.d/mariadb-server.cnf
	</nowiki>}}		</nowiki>}}

			== TLS/SSL Configuration ==

			On Alpine Linux 3.23 and Edge, '''mariadb-connector-c''' is on the 3.4.x release series. Because it has different TLS validation behaviour than the 3.3.x series, a change in TLS peer verification with self-signed certificates is being addressed as issue {{Issue\|17798}}. A workaround has been reported in the issue summary and [https://social.treehouse.systems/@ariadne/115742811691619234 elsewhere]; if using self-signed certificates, one will need to either:- {{Pill\|\|text=v3.23.x}}
			* trust the self-signed CA; or
			* set environment variable {{ic\|<nowiki>MARIADB_TLS_DISABLE_PEER_VERIFICATION=1</nowiki>}}

	== Updating or coming from upgrading ==		== Updating or coming from upgrading ==

2025-08-20T22:04:52Z

Updated names from mysql-named scripts to mariadb-named scripts, since the former will be deprecated in the future.

← Older revision		Revision as of 22:04, 20 August 2025
Line 58:		Line 58:
	Normal initialization of mariadb can be done as follows:		Normal initialization of mariadb can be done as follows:

	# Initialize MySQL Data Directory. <code>~~mysql_install_db~~ --user=mysql --datadir=/var/lib/mysql</code>		# Initialize MySQL Data Directory. <code>mariadb-install-db --user=mysql --datadir=/var/lib/mysql</code>
	# Start the main service. At this point there will be no root password set. <code>rc-service mariadb start</code>		# Start the main service. At this point there will be no root password set. <code>rc-service mariadb start</code>
	# Secure the database by running <code>~~mysql_secure_installation~~</code>		# Secure the database by running <code>mariadb-secure-installation</code>
	# Setup permissions for managing others users and databases see: '''[[#Configuration\|Configuration]]'''		# Setup permissions for managing others users and databases see: '''[[#Configuration\|Configuration]]'''
	# Add MariaDb to OpenRC. <code>rc-update add mariadb default</code>		# Add MariaDb to OpenRC. <code>rc-update add mariadb default</code>

2025-06-07T02:12:33Z

Add a missing step

← Older revision		Revision as of 02:12, 7 June 2025
Line 58:		Line 58:
	Normal initialization of mariadb can be done as follows:		Normal initialization of mariadb can be done as follows:

			# Initialize MySQL Data Directory. <code>mysql_install_db --user=mysql --datadir=/var/lib/mysql</code>
	# Start the main service. At this point there will be no root password set. <code>rc-service mariadb start</code>		# Start the main service. At this point there will be no root password set. <code>rc-service mariadb start</code>
	# Secure the database by running <code>mysql_secure_installation</code>		# Secure the database by running <code>mysql_secure_installation</code>

2025-04-09T14:39:54Z

← Older revision		Revision as of 14:39, 9 April 2025
Line 140:		Line 140:
	* [[Production LAMP system: Lighttpd + PHP + MySQL]]		* [[Production LAMP system: Lighttpd + PHP + MySQL]]

	~~[[Category:Newbie]]~~
	[[Category:Server]]		[[Category:Server]]
	[[Category:Database]]		[[Category:Database]]

2025-03-11T23:43:54Z

Create a user: this is not enough

← Older revision		Revision as of 23:43, 11 March 2025
Line 132:		Line 132:

	''NB: @'%' allow connection from any host''		''NB: @'%' allow connection from any host''

			This is insufficient to allow remote access. See [https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ Configuring MariaDB for Remote Client Access].

	= See Also =		= See Also =

2025-03-11T23:42:39Z

Create a user: ce

← Older revision		Revision as of 23:42, 11 March 2025
Line 125:		Line 125:

	= Create a user =		= Create a user =
	You ~~should~~ want to create a user with ~~will~~ access to a database ~~remotly~~		You may want to create a user with remote access to the database.

	~~So open~~ mariadb Client: <code>mariadb</code>		Open mariadb Client: <code>mariadb</code>

	add the user with associated host and password: <code> CREATE OR REPLACE USER admin@'%' IDENTIFIED BY 'ASecurePassword';</code>		add the user with associated host and password: <code> CREATE OR REPLACE USER admin@'%' IDENTIFIED BY 'ASecurePassword';</code>

	''NB: @'%' allow connection from ~~anny~~ host''		''NB: @'%' allow connection from any host''

	= See Also =		= See Also =

2025-03-11T23:11:17Z

Configuration: secure-installation

← Older revision		Revision as of 23:11, 11 March 2025
Line 65:		Line 65:
	== Configuration ==		== Configuration ==

	In order to help with the basic configuration of the database engine, MariaDB provides ~~<code>mysql_secure_installation<~~/~~code>~~.		In order to help with the basic configuration of the database engine, MariaDB provides [https://mariadb.com/kb/en/mariadb-secure-installation/ mariadb-secure-installation].

			Many of the reasons for running this script are no longer necessary, since MariaDB has defaulted to Unix socket authentication since MariaDB 10.4.

	This script walks you through the basics of securing the database. The options are explained below.		This script walks you through the basics of securing the database. The options are explained below.

2025-03-11T23:08:14Z

No basis for this claim

← Older revision		Revision as of 23:08, 11 March 2025
Line 1:		Line 1:
	[https://mariadb.org/ MariaDB] is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.		[https://mariadb.org/ MariaDB] is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.

	'''This is the general documentation for normal and common general usage, for professional usage please use [[MySQL]] that is the same as MariaDB but with several modifications focused on production and security!'''

	== Installation ==		== Installation ==

2024-12-30T16:51:29Z

Create a user

← Older revision		Revision as of 16:51, 30 December 2024
Line 128:		Line 128:
	So open mariadb Client: <code>mariadb</code>		So open mariadb Client: <code>mariadb</code>

	add the user with associated host and password: <code> CREATE OR REPLACE USER admin@'~~192.168.~~%' IDENTIFIED BY 'ASecurePassword';</code>		add the user with associated host and password: <code> CREATE OR REPLACE USER admin@'%' IDENTIFIED BY 'ASecurePassword';</code>

	''NB: @'~~192.168.~~%' allow connection from host ~~with ip in 192.168.X.X~~''		''NB: @'%' allow connection from anny host''

	= See Also =		= See Also =

2024-12-30T16:48:46Z

Create a user

← Older revision		Revision as of 16:48, 30 December 2024
Line 128:		Line 128:
	So open mariadb Client: <code>mariadb</code>		So open mariadb Client: <code>mariadb</code>

	add the user with associated host and password: <code> CREATE OR REPLACE USER ~~adminlocal~~@'192.168.%' IDENTIFIED BY 'ASecurePassword';</code>		add the user with associated host and password: <code> CREATE OR REPLACE USER admin@'192.168.%' IDENTIFIED BY 'ASecurePassword';</code>

	''NB: @'192.168.%' allow connection from host with ip in 192.168.X.X''		''NB: @'192.168.%' allow connection from host with ip in 192.168.X.X''