[PROBLEM] MySQL cannot create db

[teekay]

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