2011-11-16, 16:14
Fruitfly Wrote:CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
then this error came up:
ERROR 1396 (HY000): Operation CREATE USER failed for 'xbmc'@'%'
Going to make my first post count...
I don't know a thing about MySQL. But I had the same problem. Issues stems from which character is used "`" (located next to the 1 on the keyboard) verse " ' " (located...next to enter). I don't understand the syntax well enough. But follow the syntax below...
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
Notice the different character before and after `xbmc_%`. verse 'xbmc'@'%'.
I have been try to get synchronizing multiple XBMC with nightly for over a week without luck. I keep telling myself to wait for final. But I can't let it go. I have learn quite a few things about MySQL in the last few days. Which I see as a plus