MySQL/Setting up MySQL - Revision history

Crystalp at 16:52, 8 April 2026

2026-04-08T16:52:02Z

← Older revision		Revision as of 16:52, 8 April 2026
Line 275:		Line 275:
	If you don't have one already, create a docker-compose.yaml file.		If you don't have one already, create a docker-compose.yaml file.

	Here's an example service definition for a mariadb container using the ~~offical~~ MariaDB LTS (Long Term Support) image:		Here's an example service definition for a mariadb container using the official MariaDB LTS (Long Term Support) image:

	services:		services:
Line 296:		Line 296:
	<code>sudo docker compose up -d mariadb</code>		<code>sudo docker compose up -d mariadb</code>

	~~This~~ will create a root user with the password you gave in the Docker Compose file. It will also create a user called "kodi" (please note that you can use any username you want - default is usually "kodi" with a password of "kodi"). The kodi user will NOT have appropriate access until you grant the correct privileges.		On first run this will create a root user with the password you gave in the Docker Compose file. It will also create a user called "kodi" (please note that you can use any username you want - default is usually "kodi" with a password of "kodi"). The kodi user will NOT have appropriate access until you grant the correct privileges.

	So, with the container running:		So, with the container running:

Crystalp: Must assign some value to the env variable MARIADB_AUTO_UPGRADE for the MariaDB docker to auto upgrade with major releases

2026-04-08T16:30:51Z

Must assign some value to the env variable MARIADB_AUTO_UPGRADE for the MariaDB docker to auto upgrade with major releases

← Older revision		Revision as of 16:30, 8 April 2026
Line 290:		Line 290:
	- MYSQL_PASSWORD=kodi		- MYSQL_PASSWORD=kodi
	- MYSQL_USER=kodi		- MYSQL_USER=kodi
	- MARIADB_AUTO_UPGRADE=		- MARIADB_AUTO_UPGRADE=1
	restart: unless-stopped		restart: unless-stopped

Crystalp: include the current MySQL and MariaDB LTS versions

2026-04-08T16:09:21Z

include the current MySQL and MariaDB LTS versions

← Older revision		Revision as of 16:09, 8 April 2026
Line 10:		Line 10:
	'''Version Requirements'''		'''Version Requirements'''

	The latest LTS (long term support) versions of MySQL or MariaDB ~~are recommended~~ for ~~the~~ continuing support and regular bug/security fixes.<br />		Recommended:<br />
	~~The minimum requirements are~~:		The latest LTS (long term support) versions of MySQL or MariaDB, for continuing support and regular bug/security fixes.<br />
			They were MySQL 8.4.x and MariaDB 11.8.x at the time of writing.

			Minimum:

	{\|class="prettytable"		{\|class="prettytable"

Crystalp: mark the page "updated to v22"

2026-04-08T12:45:59Z

mark the page "updated to v22"

← Older revision		Revision as of 12:45, 8 April 2026
Line 332:		Line 332:
	{{Next\|[[MySQL/Setting up Kodi\|Setting up Kodi]]}}		{{Next\|[[MySQL/Setting up Kodi\|Setting up Kodi]]}}

	{{~~Isengard~~ updated}}		{{updated\|22}}

Crystalp: mysql/mariadb version requirements

2026-04-08T12:43:43Z

mysql/mariadb version requirements

@@ Line 7: / Line 7: @@
 {{redv|'''Also:'''| Some versions of MySQL set their passwords to expire by default, '''even the root password'''!  If the password expires, Kodi cannot access the database and the TV Series and Movies libraries will disappear.<br />
 To avoid this and/or fix it after it happens, make sure the account's password does not expire. (See: https://dev.mysql.com/doc/refman/5.7/en/password-management.html )}}
 MySQL/MariaDB can be installed on just about every major OS and NAS:
 =Ubuntu Linux=

DarrenHill: Update minimum version of MySQL and the date

2026-04-07T17:58:31Z

Update minimum version of MySQL and the date

← Older revision		Revision as of 17:58, 7 April 2026
Line 10:		Line 10:
	MySQL/MariaDB can be installed on just about every major OS and NAS:		MySQL/MariaDB can be installed on just about every major OS and NAS:

	{{redv\|'''Important:'''\| Please use only supported versions of the MySQL or MariaDB server. As of ~~January 2019~~, this is MySQL in at least version 5.7 or MariaDB in at least version 5.5, but version 10.3+ is recommended.}}		{{redv\|'''Important:'''\| Please use only supported versions of the MySQL or MariaDB server. As of April 2026, this is MySQL in at least version 5.7.9 or MariaDB in at least version 5.5, but version 10.3+ is recommended.}}

	=Ubuntu Linux=		=Ubuntu Linux=

Crystalp: remove misleading unnecessary quotes

2025-07-31T03:54:08Z

remove misleading unnecessary quotes

← Older revision		Revision as of 03:54, 31 July 2025
Line 268:		Line 268:
	- /your/host/path/to/mariadb/configuration/files:/config		- /your/host/path/to/mariadb/configuration/files:/config
	environment:		environment:
	- MYSQL_ROOT_PASSWORD="YOUR_MARIADB_ROOT_PASSWORD"		- MYSQL_ROOT_PASSWORD=YOUR_MARIADB_ROOT_PASSWORD
	- MYSQL_PASSWORD=kodi		- MYSQL_PASSWORD=kodi
	- MYSQL_USER=kodi		- MYSQL_USER=kodi

Crystalp: /* Docker */

2025-02-13T16:16:49Z

Docker

← Older revision		Revision as of 16:16, 13 February 2025
Line 271:		Line 271:
	- MYSQL_PASSWORD=kodi		- MYSQL_PASSWORD=kodi
	- MYSQL_USER=kodi		- MYSQL_USER=kodi
	- MARIADB_AUTO_UPGRADE		- MARIADB_AUTO_UPGRADE=
	restart: unless-stopped		restart: unless-stopped

Bossanova808: /* Docker */

2025-02-13T03:56:13Z

Docker

← Older revision		Revision as of 03:56, 13 February 2025
Line 252:		Line 252:
	'''Mariadb in Docker Container:'''		'''Mariadb in Docker Container:'''

	If you are new to Docker, first install Docker for your specific OS. Containers are OS independent		If you are new to Docker, first install Docker for your specific OS. Containers are OS independent - see https://www.docker.com/ for more general information about Docker.
	https://www.docker.com/

	If you don't have one already, create a docker-compose.yaml file.		If you don't have one already, create a docker-compose.yaml file.
Line 259:		Line 258:
	Here's an example service definition for a mariadb container using the offical MariaDB LTS (Long Term Support) image:		Here's an example service definition for a mariadb container using the offical MariaDB LTS (Long Term Support) image:

	~~<code>~~
	services:		services:
	mariadb:		mariadb:
Line 267:		Line 265:
	- 3306:3306		- 3306:3306
	volumes:		volumes:
	- /your/path/to/database/files/:/var/lib/mysql		- /your/host/path/to/database/files/:/var/lib/mysql
	- /your/path/to/mariadb/configuration/files:/config		- /your/host/path/to/mariadb/configuration/files:/config
	environment:		environment:
	- MYSQL_ROOT_PASSWORD="YOUR_MARIADB_ROOT_PASSWORD"		- MYSQL_ROOT_PASSWORD="YOUR_MARIADB_ROOT_PASSWORD"
Line 275:		Line 273:
	- MARIADB_AUTO_UPGRADE		- MARIADB_AUTO_UPGRADE
	restart: unless-stopped		restart: unless-stopped
	~~</code>~~

	To bring the new container up, (in folder where docker-compose.yaml is located):		To bring the new container up, (in folder where docker-compose.yaml is located):
Line 284:		Line 281:
	So, with the container running:		So, with the container running:

	<code>sudo docker exec -it mariadb bash</code> (to ~~run~~ a ~~command line~~ inside the container.		<code>sudo docker exec -it mariadb bash</code> (to access a shell inside the container).

	Then in that shell, run:		Then, in that shell, run:

	<code>mariadb -u root -p</code> (enter root password from Docker Compose file)		<code>mariadb -u root -p</code> (enter root password from Docker Compose file)

Bossanova808: /* Docker */

2025-02-13T03:47:02Z

Docker

← Older revision		Revision as of 03:47, 13 February 2025
Line 255:		Line 255:
	https://www.docker.com/		https://www.docker.com/

	~~PLEASE NOTE: This install was done on Linux Mint 22~~, ~~there may be differences for other OS~~		If you don't have one already, create a docker-compose.yaml file.

	~~Create~~ a ~~docker-compose.yaml file. Contents are as follows...~~		Here's an example service definition for a mariadb container using the offical MariaDB LTS (Long Term Support) image:

	<code>		<code>
	services:		services:
	mariadb:		mariadb:
	image: mariadb:~~latest~~		image: mariadb:lts
	container_name: mariadb		container_name: mariadb
	ports:		ports:
	- 3306:3306		- 3306:3306
	volumes:		volumes:
	- ~/~~apps~~/~~mariadb~~:/var/lib/mysql		- /your/path/to/database/files/:/var/lib/mysql
	- /~~home~~/~~"YOURHOMEFOLDER"~~/mariadb/~~config~~:/config		- /your/path/to/mariadb/configuration/files:/config
	environment:		environment:
	~~- TZ="COUNTRY/CITY~~		- MYSQL_ROOT_PASSWORD="YOUR_MARIADB_ROOT_PASSWORD"
	~~- PUID=1000~~
	~~- PGID=1000~~
	- MYSQL_ROOT_PASSWORD="~~CREATEMARIADBROOTPASSWORD~~"
	- MYSQL_PASSWORD=kodi		- MYSQL_PASSWORD=kodi
	- MYSQL_USER=kodi		- MYSQL_USER=kodi
Line 280:		Line 277:
	</code>		</code>

	~~From command line~~ (in folder where docker-compose.yaml is located):		To bring the new container up, (in folder where docker-compose.yaml is located):
	<code>sudo docker compose up -d</code> ~~(or "add stack" in Portainer).~~		<code>sudo docker compose up -d mariadb</code>
	This will create a root user with the password you gave in the Docker Compose file. It will also create a user called "kodi" (please note that you can use any username you want - default is usually "kodi" with a password of "kodi"). The kodi user will NOT have access until you grant the correct privileges. So, after it has finished installing...

	<code>sudo docker exec -it mariadb bash</code> (to ~~get~~ inside the container. ~~Your container name may be different).~~		This will create a root user with the password you gave in the Docker Compose file. It will also create a user called "kodi" (please note that you can use any username you want - default is usually "kodi" with a password of "kodi"). The kodi user will NOT have appropriate access until you grant the correct privileges.

			So, with the container running:

			<code>sudo docker exec -it mariadb bash</code> (to run a command line inside the container.

			Then in that shell, run:

	<code>mariadb -u root -p</code> (enter root password from Docker Compose file)		<code>mariadb -u root -p</code> (enter root password from Docker Compose file)
Line 294:		Line 296:
	<code>FLUSH PRIVILEGES;</code>		<code>FLUSH PRIVILEGES;</code>

	~~That should be all~~ you ~~need to do to get Mariadb up and running~~		Then you can exit the mariadb shell.

	=Restricting MySQL access rights=		=Restricting MySQL access rights=
	'''Optional:''' '''If you only use the MySQL server for Kodi and that server has non-critical data on it, then this probably not necessary.'''		'''Optional:''' '''If you only use the MySQL server for Kodi and that server has non-critical data on it, then this probably not necessary.'''