MySQL - Revision history

Amet at 07:54, 4 January 2020

2020-01-04T07:54:58Z

← Older revision		Revision as of 03:54, 4 January 2020
Line 154:		Line 154:

	*Devices running Arch Linux ARM (such as the PogoPlug, Dockstar, etc) can use the [[HOW-TO:Share libraries using MySQL/Setting up MySQL/ALARM\|Arch Linux instructions]] on this page.		*Devices running Arch Linux ARM (such as the PogoPlug, Dockstar, etc) can use the [[HOW-TO:Share libraries using MySQL/Setting up MySQL/ALARM\|Arch Linux instructions]] on this page.
	*[http://~~quixventure~~.~~com/2011/12/configure-a-synology-nas-as-mysql-server-for-xbmc~~/ Synology NAS as MySQL server for XBMC] ~~and http://youtu.be/3PmmDtK65ks~~		*[http://youtu.be/3PmmDtK65ks Synology NAS as MySQL server for XBMC]
	*http://www.robvanhamersveld.nl/2013/02/05/share-your-xbmc-12-0-library-on-a-synology-ds-or-other-nas/ Synology DS with MySQL guide based on Frodo		*http://www.robvanhamersveld.nl/2013/02/05/share-your-xbmc-12-0-library-on-a-synology-ds-or-other-nas/ Synology DS with MySQL guide based on Frodo
	*http://forum.mrmc.tv/showthread.php?tid=172548 - unRAID		*http://forum.mrmc.tv/showthread.php?tid=172548 - unRAID

Amet at 08:57, 13 December 2019

2019-12-13T08:57:12Z

← Older revision		Revision as of 04:57, 13 December 2019
Line 7:		Line 7:

	MrMC v3.x is compatible with Kodi 17.* databases.		MrMC v3.x is compatible with Kodi 17.* databases.

			MrMC v3.9.3 is compatible with Kodi 18.* databases.

			: {{color\|red\|With Kodi 18 database bump TV Show database listing seems to be a bit slow.}} (see here: https://forum.kodi.tv/showthread.php?tid=340340)
			:: fix is mentioned here -> https://forum.libreelec.tv/thread/13990-mariadb-mysql-server-addon/?postID=108409#post108409
			:: <code># * Query Cache Configuration<br />query_cache_limit = 2M (was 1)<br />query_cache_size = 32M (was 16)</code>



	{{-}}		{{-}}

Amet at 15:39, 25 February 2019

2019-02-25T15:39:27Z

← Older revision		Revision as of 11:39, 25 February 2019
Line 241:		Line 241:

	Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }}		Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }}

			== Connect MrMC using Settings/Services/MySql page as below ==
			<tabber>
			Ariana Skin=
			[[File:mysql ariana.png\|600px\|center]]

			\|-\|

			Opacity Skin=
			[[File:mysql_opacity.png\|600px\|center]]

			</tabber>

Amet: /* Compatibility */

2017-12-18T18:56:59Z

Compatibility

← Older revision		Revision as of 14:56, 18 December 2017
Line 5:		Line 5:

	MrMC v2.x is compatible with Kodi 16.* databases.		MrMC v2.x is compatible with Kodi 16.* databases.

			MrMC v3.x is compatible with Kodi 17.* databases.

	{{-}}		{{-}}

NedScott at 18:41, 29 August 2016

2016-08-29T18:41:26Z

← Older revision		Revision as of 14:41, 29 August 2016
Line 14:		Line 14:

	<tabber>		<tabber>
	Ubuntu ~~Linux~~=		Ubuntu=
	'''Ubuntu Linux:'''		'''Ubuntu Linux:'''
	#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''		#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''
Line 33:		Line 33:
	\|-\|		\|-\|

	Arch ~~Linux~~=		Arch=
	'''Arch Linux:'''		'''Arch Linux:'''
	*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.		*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.
Line 49:		Line 49:
	\|-\|		\|-\|

	RedHat ~~based Linux~~=		RedHat=
	'''RedHat based Linux (RHEL, CentOS, Fedora):'''		'''RedHat based Linux (RHEL, CentOS, Fedora):'''
	#<code>$sudo yum install mysql-server</code>		#<code>$sudo yum install mysql-server</code>
Line 68:		Line 68:
	\|-\|		\|-\|

	~~Mac~~ OS X=		OS X=
	'''Mac OS X:'''		'''Mac OS X:'''
	#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/		#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/
Line 150:		Line 150:
	\|-\|		\|-\|

	FreeNAS ~~and~~ freeBSD=		FreeNAS/freeBSD=

	== About FreeNAS ==		== About FreeNAS ==
Line 225:		Line 225:
	* <code>quit;</code>		* <code>quit;</code>

	~~\|-\|~~		</tabber>

	Restricting MySQL access rights=		== Restricting MySQL access rights ==
	'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''		'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''
	For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.		For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.
Line 239:		Line 239:

	Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }}		Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }}
	~~</tabber>~~

NedScott at 18:39, 29 August 2016

2016-08-29T18:39:50Z

← Older revision		Revision as of 14:39, 29 August 2016
Line 150:		Line 150:
	\|-\|		\|-\|

	~~tab7=~~FreeNAS and freeBSD		FreeNAS and freeBSD=

	== About FreeNAS ==		== About FreeNAS ==

NedScott at 18:39, 29 August 2016

2016-08-29T18:39:23Z

← Older revision		Revision as of 14:39, 29 August 2016
Line 33:		Line 33:
	\|-\|		\|-\|

	Arch~~ ~~Linux=		Arch Linux=
	'''Arch Linux:'''		'''Arch Linux:'''
	*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.		*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.
Line 49:		Line 49:
	\|-\|		\|-\|

	RedHat~~ ~~based~~ ~~Linux=		RedHat based Linux=
	'''RedHat based Linux (RHEL, CentOS, Fedora):'''		'''RedHat based Linux (RHEL, CentOS, Fedora):'''
	#<code>$sudo yum install mysql-server</code>		#<code>$sudo yum install mysql-server</code>
Line 68:		Line 68:
	\|-\|		\|-\|

	Mac~~ ~~OS~~ ~~X=		Mac OS X=
	'''Mac OS X:'''		'''Mac OS X:'''
	#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/		#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/
Line 140:		Line 140:
	\|-\|		\|-\|

	Other~~ ~~NAS=		Other NAS=
	MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:		MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:

Line 150:		Line 150:
	\|-\|		\|-\|

	tab7=FreeNAS~~ ~~and~~ ~~freeBSD		tab7=FreeNAS and freeBSD

	== About FreeNAS ==		== About FreeNAS ==
Line 227:		Line 227:
	\|-\|		\|-\|

	Restricting~~ ~~MySQL~~ ~~access~~ ~~rights=		Restricting MySQL access rights=
	'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''		'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''
	For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.		For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.

NedScott at 18:38, 29 August 2016

2016-08-29T18:38:29Z

← Older revision		Revision as of 14:38, 29 August 2016
Line 14:		Line 14:

	<tabber>		<tabber>
	Ubuntu~~ ~~Linux=		Ubuntu Linux=
	'''Ubuntu Linux:'''		'''Ubuntu Linux:'''
	#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''		#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''

NedScott at 18:37, 29 August 2016

2016-08-29T18:37:37Z

← Older revision		Revision as of 14:37, 29 August 2016
Line 14:		Line 14:

	<tabber>		<tabber>
	~~tab1=~~Ubuntu Linux		Ubuntu Linux=
	'''Ubuntu Linux:'''		'''Ubuntu Linux:'''
	#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''		#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''
Line 33:		Line 33:
	\|-\|		\|-\|

	~~tab2=~~Arch Linux		Arch Linux=
	'''Arch Linux:'''		'''Arch Linux:'''
	*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.		*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.
Line 49:		Line 49:
	\|-\|		\|-\|

	~~tab3=~~RedHat based Linux		RedHat based Linux=
	'''RedHat based Linux (RHEL, CentOS, Fedora):'''		'''RedHat based Linux (RHEL, CentOS, Fedora):'''
	#<code>$sudo yum install mysql-server</code>		#<code>$sudo yum install mysql-server</code>
Line 68:		Line 68:
	\|-\|		\|-\|

	~~Tab4=~~Mac OS X		Mac OS X=
	'''Mac OS X:'''		'''Mac OS X:'''
	#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/		#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/
Line 94:		Line 94:
	\|-\|		\|-\|

	~~tab5~~=~~Windows~~		Windows=
	== Installing MySQL on Windows ==		== Installing MySQL on Windows ==
	If you have chocolatey installed run '''choco install mysql'''		If you have chocolatey installed run '''choco install mysql'''
Line 140:		Line 140:
	\|-\|		\|-\|

	~~tab6=~~Other NAS		Other NAS=
	MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:		MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:

Line 227:		Line 227:
	\|-\|		\|-\|

	~~tab8=~~Restricting MySQL access rights		Restricting MySQL access rights=
	'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''		'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''
	For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.		For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.

NedScott at 18:35, 29 August 2016

2016-08-29T18:35:02Z

← Older revision		Revision as of 14:35, 29 August 2016
Line 14:		Line 14:

	<tabber>		<tabber>
	tab1 = Ubuntu Linux		tab1=Ubuntu Linux
	'''Ubuntu Linux:'''		'''Ubuntu Linux:'''
	#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''		#<code>$sudo apt-get install mysql-server</code> ''(see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )''
Line 33:		Line 33:
	\|-\|		\|-\|

	tab2 = Arch Linux		tab2=Arch Linux
	'''Arch Linux:'''		'''Arch Linux:'''
	*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.		*Please note: Arch, along with many other distributions, has migrated to the faster and more open MariaDB. It is a drop in replacement to MySQL and, thus, mrmc will require no modifications to work with it.
Line 49:		Line 49:
	\|-\|		\|-\|

	tab3 = RedHat based Linux		tab3=RedHat based Linux
	'''RedHat based Linux (RHEL, CentOS, Fedora):'''		'''RedHat based Linux (RHEL, CentOS, Fedora):'''
	#<code>$sudo yum install mysql-server</code>		#<code>$sudo yum install mysql-server</code>
Line 68:		Line 68:
	\|-\|		\|-\|

	Tab4 = Mac OS X		Tab4=Mac OS X
	'''Mac OS X:'''		'''Mac OS X:'''
	#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/		#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/
Line 94:		Line 94:
	\|-\|		\|-\|

	tab5 = Windows		tab5=Windows
	== Installing MySQL on Windows ==		== Installing MySQL on Windows ==
	If you have chocolatey installed run '''choco install mysql'''		If you have chocolatey installed run '''choco install mysql'''
Line 140:		Line 140:
	\|-\|		\|-\|

	tab6 = Other NAS		tab6=Other NAS
	MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:		MySQL can also be installed on some [[w:network-attached storage\|network-attached storage (NAS)]] device devices. Here are some guides for various NAS devices that can have a MySQL server installed:

Line 150:		Line 150:
	\|-\|		\|-\|

	tab7 = FreeNAS and freeBSD		tab7=FreeNAS and freeBSD

	== About FreeNAS ==		== About FreeNAS ==
Line 227:		Line 227:
	\|-\|		\|-\|

	tab8 = Restricting MySQL access rights		tab8=Restricting MySQL access rights
	'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''		'''Optional:''' '''If you only use the MySQL server for mrmc and that server has non-critical data on it, then this probably not necessary.'''
	For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.		For a more secure MySQL installation use these 2 commands to grant permission only to databases mrmc uses. This is useful if you plan on using your MySQL server for more than just mrmc, or if you're worried about your internal network being exposed and wanting to lock things down more, etc.