Dropping Databases is fun, but there I found that providing the security visa-vi MySQL to XBMC to be a little more then "GRANT ALL... TO XBMC". Let me see if I can remember the commands:
(at the command prompt)
mysql -u xbmc -p
(will prompt for PWD)
SHOW DATABASES;
USE DATABASE <YOUR DATABASE>;
SHOW TABLES (I think);
If that does not work for you:
mysql -u root -p 192.168.1.6 (I think that was your MySQL IP)
(will prompt for ROOT PWD)
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@
localhost IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'192.168.1.*' IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
UPDATE user SET Password=PASSWORD('xbmc') WHERE user='xbmc';
Now to bless with Holy Penguin Pee:
USE DATABASE MyVideo27; (or whatever you named it)
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@
localhost IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'192.168.1.*' IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
USE DATABASE MyMusic27; (oweyni)
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@
localhost IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'192.168.1.*' IDENTIFIED BY 'xbmc' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;
That worked for me... The Penguin stuff is just in case the first couple lines do not work, but I had to do it all.
I found these two links to be helpful, Mythtv albiet:
https://help.ubuntu.com/community/MythTV...leshooting
http://www.mythtv.org/wiki/Category:MySQL
Go ahead and test again by logging in manually with xbmc.
BTW, in your advanged settings, how did you get your EPG info into MySQL? I am interested in doing this myself...
--Cheers.