MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
>Wolrah (XBMC user does not need *.* privs, `xbmc_%` allows database updates while preventing XBMC from touching other DBs or doing other things on server.) |
(Undo revision by Wolrah default MySQL DB names don't start out with "xbmc_" and security is hardly an issue for most users reading this page. Feel free to make a note on the advanced notes page for extra security.) |
||
Line 16: | Line 16: | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ||
##Type in: <code>GRANT ALL ON | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool | #Close out the command line tool | ||
=Mac OS X= | =Mac OS X= | ||
Line 28: | Line 28: | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ||
##Type in: <code>GRANT ALL ON | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool | #Close out the command line tool | ||
=Windows= | =Windows= | ||
Line 39: | Line 39: | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ||
##Type in: <code>GRANT ALL ON | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool | #Close out the command line tool | ||
#In '''Windows 7''', you may need to make an exception in the "Windows Firewall" | #In '''Windows 7''', you may need to make an exception in the "Windows Firewall" |
Revision as of 21:23, 22 March 2012
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.
On a computer
INCOMPLETE: This page or section is incomplete. Please add information or correct uncertain data which is marked with a ? |
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.
On a NAS
MySQL can also be installed on some network-attached storage (NAS) device devices. See one of the following guides for more info: