2015-12-02, 06:52
(2015-12-01, 21:07)Heiko123 Wrote: Hello,
it is possibly that it's a problem with MySQL 5.7.x. ?
I don't get a database together within kodi16 beta 3, but with Kodi 15 is all right.
see the Log: http://pastebin.com/1UmgXfqs
The error you are seeing is a permission error, most probably "ERROR 1142 (42000): TRIGGER command denied to user".
Can you check the permissions your xbmc user has, by executing the following in MySQL:
Code:
SHOW GRANTS FOR 'xbmc';
You should see something like:
Code:
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*AE5E9625CF009AEDCF5962E6E83C5AC7ED15A9E1'
Another check would be:
Code:
SELECT User, Trigger_priv FROM mysql.user WHERE User LIKE 'xbmc%'
which should return:
Code:
User Trigger_priv
---- ------------
xbmc Y
If it's any different then I can only assume you have missed out the step:
Code:
GRANT ALL ON *.* TO 'xbmc';