MySQL No Worky
#1
Can't seem to get XBMC to connect to mysql.

Running latest stable xbmc & windows 7 all around

What I did
  • Installed mysql server 5.1
  • created database for music & video
  • created user and Granted All on *.*
  • setup advancedsettings.xml file with proper fields populated
  • restarted xbmc and imported old video library
  • setup advancedsettings.xml on other xbmc installs

but no worky...

Logging into the mysql and showing tables returns "Empty Set"
Looking in the xbmc logs it is seeing the advancedsettings.xml file and parsing it without errors.
Windows firewall is completely off

I downloaded MySQL workbench and tried to connect but I'm not sure I'm doing it right. I'm not familiar with the software I went to the GRT Shell and typed:
mysql -h 192.168.1.213 -u xbmc -p
I was returned luart: error: stdin:1: '=' expected near '-'

Please point out the obvious and make me feel stupid (in a good way). Thanks in advance.
Reply
#2
I think mysql db support was introduce in the nightly builds.

so the last stable xbmc (9.11) does not support it.

try Dharma Beta 2, it works like a charm Smile
Hardware: Revo 3610 + SSD - Harmony 700 Remote
Software: XBMCBuntu Gotham - Sickbeard - SabNZBd+

Image
Reply
#3
You were right. Thanks for the tip. Running beta 2 & worked after a reboot or 2. Thanks.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL No Worky0