[PROBLEM] MySQL cannot create db

[thebestneo]

(28th Jan, 2014 06:44 AM)teekay Wrote:  Here is how I did it, maybe it helps.

Code:

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT TRIGGER ON `MyMusic%`.* TO 'xbmc'@'%';
GRANT TRIGGER ON `MyVideos%`.* TO 'xbmc'@'%';

The last two only work on newer MySQL version >= 5.5 IIRC. Older ones need GRANT SUPER ON ...

Also read following about the <name> tag, mabe you have an issue with that one.
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Setting_up_XBMC#Name_tag

First 3 lines are the same of mine.
I try others, i have mysql 5.5.

I didn't set the name tag...