Source: wiki.xbmc.org
Issues were reported with MySQL 5.6. Use MySQL 5.5 instead.
Future Gotham feature: This is now fixed in nightly builds!
Windows:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
and press returnGRANT ALL ON *.* TO 'xbmc';
and press returnIf this occurs to you, try amending Step 2 above to read GRANT ALL ON *.* TO 'xbmc'@'xxx.xxx.xxx.%';
where xxx.xxx.xxx is the first three quadrants of your home network's IP address (192.168.1 for example) and % as the last quadrant to allow addresses on the same subnet to connect.
GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
See Category:File Sharing for some of the file sharing methods that work with XBMC.
You only need to do the exporting steps if you are migrating an existing local library to a MySQL database.
Ensure MySQL-user has enough permissions.
Else it results in an error like:
ERROR: SQL: The table does not exist Query: SELECT idVersion FROM version
advancedsettings.xml: |
<advancedsettings> <videodatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </videodatabase> <musicdatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </musicdatabase> <videolibrary> <importwatchedstate>true</importwatchedstate> </videolibrary> </advancedsettings> See also this note about using the <name> tag: #Name tag |
***.***.***.***
with local network IP address of your MySQL server. If you installed MySQL on a Windows machine, do not use its NetBIOS name, as not all devices may be able to resolve them.
You can now add files and update the library from any of your XBMC devices and the library for all of them will stay in sync.
An additional <name>
tag can be used for both the video and music entries in advancedsettings.xml if you want to change the name of the database.
The name tag is not required (XBMC will use a default "MyVideos" and "MyMusic" DB name) and it is recommended to not include it if you only need one library, as some users have reported problems/bugs when it was included.
The tag is only needed if you want to have separate databases on the same MySQL server, like for more than one shared library. For example, if you want to create multiple profiles, each with their own shared library, so that each XBMC device can "log-into" that library.
Designed, maintained and lubricated since 2013 by George.
© Copyright gVrakas.com
All rights reserved.