MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
Line 115: | Line 115: | ||
*http://forum.xbmc.org/showthread.php?tid=172548 - unRAID | *http://forum.xbmc.org/showthread.php?tid=172548 - unRAID | ||
=FreeNAS and | =FreeNAS and freeBSD= | ||
== About FreeNAS == | == About FreeNAS == | ||
Line 124: | Line 122: | ||
FreeNAS is a FreeBSD based NAS system that can be run on almost any hardware - it uses ZFS for disk and file management. It is used at home and in enterprise businesses. 99% of tasks can be done via the web interface. | |||
99% of tasks can be done via the web interface. | |||
Line 157: | Line 154: | ||
*<code>pkg_add -r mysql55-server</code> | *<code>pkg_add -r mysql55-server</code> | ||
*<code>pkg_add -r nano</code> | *<code>pkg_add -r nano</code> nano is a text editor you will need shortly | ||
We now need to enable mysql in rc.conf | |||
*<code>nano /etc/rc.conf</code> | *<code>nano /etc/rc.conf</code> | ||
Line 165: | Line 164: | ||
*<code>mysql_enable="YES"</code> | *<code>mysql_enable="YES"</code> | ||
save the file and exit (see bottom of nano edit page for info | save the file and exit (see bottom of nano edit page for keystrokes info) | ||
*<code>service mysql-server start</code> | *<code>service mysql-server start</code> | ||
Optional step below - this is an automated script that will propt you for answers to questions. Its up to you if you do this. | |||
*<code>mysql_secure_installation</code> | *<code>mysql_secure_installation</code> | ||
Line 174: | Line 175: | ||
=== Configure mysql ready for xbmc to use === | === Configure mysql ready for xbmc to use === | ||
type in | |||
* </code>mysql -u root -p</code> | * </code>mysql -u root -p</code> | ||
You are now in mysql | You are now in mysql administration | ||
Line 184: | Line 186: | ||
* <code>GRANT ALL ON *.* TO 'xbmc';</code> | * <code>GRANT ALL ON *.* TO 'xbmc';</code> | ||
* <code>quit;</code> | * <code>quit;</code> | ||
thats it - proced to the next step below and configure XBMC to use your FreeNAS hosted XBMC MYSQL database - I love mine! | |||
Revision as of 06:18, 14 December 2013
HOW-TO:Sync multiple libraries/Contents
You'll need to choose which of your computers, XBMC devices, or NAS will be the MySQL server. The server needs to be on 24/7 or have wake-on-lan (preferably the former), and needs to have a local static IP. You will probably want the XBMC device that is hosting most or all of your videos and music to also be the MySQL server, but this is not required.
NOTICE: Users are reporting issues with MySQL 5.6. Use MySQL 5.5 instead. |
MySQL can be installed on just about every major OS:
- If your library loads slowly with MySQL then you may wish to check out these MySQL speed-up tweaks.
Next step: | Setting up XBMC |