Posts: 4
Joined: Sep 2012
Reputation:
0
I hope I am miss understanding something, but as far as I can tell you basically have to give xbmc complete access to your mysql server. From reading the installation instructions, it looks like it creates a new numbered database, maybe for every version or something? So their suggestion is to grant permissions for *everything*. Then the password is stored in clear text in an xml file.
You can limit the damage by restricting the grants after, but after every upgrade you have to fix it.
Why doesn't xbmc just use a single database and perhaps use prefixes on table names or something?
Posts: 193
Joined: May 2010
Reputation:
0
when there are changes to database structure in XBMC updates, it updates the database as well (creates a new 'versioned' one) that way you can keep your previous install working in case you want to roll back, or just test the new one.
what i do, is only give the xbmc mysql user privileges to xbmc_* databases, then in advancedsettings.xml, make your database xbmc_video and xbmc_music.
Posts: 4
Joined: Sep 2012
Reputation:
0
Ah, with the <name></name> attribute? That makes sense. Thanks!
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
Yes but <name></name> has a reputation for not working!
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 31,445
Joined: Jan 2011
Most people who set up MySQL for XBMC are only using MySQL for XBMC. Doesn't matter much, since eventually MySQL will be replaced by something else for library sharing/syncing.
Posts: 5,174
Joined: Jan 2010
Reputation:
97
Kib
Team-Kodi Member
Posts: 5,174
If you run other stuff on the MySQL server and want to seperate access it can be done quite easily.
You can restrict the user XBMC uses to only have access to the databases you created when setting up, or even use seperate instances of MySQL.
Just remember to grant full permissions when you upgrade to Gotham in a few months
Posts: 51
Joined: Nov 2011
Reputation:
0
2013-05-05, 20:42
(This post was last modified: 2013-05-05, 20:45 by guyonphone.)
I could be wrong here, so feel free to correct me anyone, but i believe the idea is to replace the use of mysql for syncing multiple xbmc machines with upnp. each xbmc instance would share out its library if it was configured too by enabling that option in the settings, and they would all just kind of see each other, and be able to play each others content. This functionality is currently avaliable in frodo, but from what i have gathered, they want to streamline it to make it more effortless, and there are certain things it cannot currently do, like mark remote content as watched.
Posts: 31,445
Joined: Jan 2011
UPnP is one approach, but there are additional ideas that also use JSON-RPC to have XBMC devices simply talk to each other, and actually "sync" individual databases. There's no sure set plan at this moment, but the devs know of a bunch of methods that could be explored that should be easier to set up and maintain than MySQL, and even offer more features and flexibility.
One thing is for sure, and that is that we won't remove MySQL support from XBMC until a suitable replacement has been found and implemented.
Posts: 31,445
Joined: Jan 2011
MySQL is already full of existing problems. No need to search for them.