xbmc/xbmc — comment on commit 5ecc52506b8d068b11cf5a28341e2c7fde727be6
File:  line 0
By gleamicus:

Sorry for not replying sooner.

re: the permissions only need the addition to create tables and not "all".

Since you're now using several databases with non-static names, the XBMC mysql user now needs permissions to all potential database names. Under the old schema you could just grant all privileges on xbmc_video.*,xbmc_music.*. Unless I'm mistaken, and I hope I am, you now need to either enumerate every possible database name (MyVideos[1-1000]?) or grant all privileges on *.*, which is absurd and poor design.

Maybe I'm wrong about what permissions are required. I hope I am. So, for clarity, what grant statements would you use? These used to work:

GRANT ALL PRIVILEGES ON `xbmc_video`.* TO 'xbmc'@'%';
GRANT ALL PRIVILEGES ON `xbmc_music`.* TO 'xbmc'@'%';

But don't any more.

In addition, stopping mysql, removing all references to the xbmc_video/xbmc_music databases in advancedsettings, and dropping the MyVideos56 database didn't resolve anything, even with xbmc@% having, essentially, mysql root access to the database server.