+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Solved Shared library database user privileges (/showthread.php?tid=362001)
Shared library database user privileges - suamikim - 2021-04-09
I just set up a shared MySql library following this guide.
Everything was working flawless but I'm a little worried about security as this step requires to give the kodi user access to all databases which makes him "root like".
I guess this is needed for automatically creating & setting up the needed databases but I'm now wondering if I could revoke those rights and restrict the user after initial setup to only have rights for the database(s) he really needs (video & music).
Is it ok to restrict the user after initial set up or will this break something in the future? E.g. does Kodi need to create new databases when updating to newer versions etc.?
Thanks & best regards,
Mike
RE: Shared library database user privileges - Klojum - 2021-04-09
Have a look at the "Restricting MySQL Access Rights" tab page on the far right on the https://kodi.wiki/view/MySQL/Setting_up_MySQL page.
RE: Shared library database user privileges - suamikim - 2021-04-09
(2021-04-09, 22:18)Klojum Wrote: Have a look at the "Restricting MySQL Access Rights" tab page on the far right on the https://kodi.wiki/view/MySQL/Setting_up_MySQL page.
Perfect, that answers all my questions!
Completely missed that tab, thank you very much!
Shared library database user privileges - Klojum - 2021-04-09
Thread marked solved.