MySQL No Worky

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
meyersmp Offline
Junior Member
Posts: 5
Joined: Oct 2010
Reputation: 0
Post: #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.
find quote
The_Dogg Offline
Fan
Posts: 377
Joined: Feb 2004
Reputation: 3
Location: Canada
Post: #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 Frodo - Sickbeard - SabNZBd+

[Image: all-clearlogo.jpg]
find quote
meyersmp Offline
Junior Member
Posts: 5
Joined: Oct 2010
Reputation: 0
Post: #3
You were right. Thanks for the tip. Running beta 2 & worked after a reboot or 2. Thanks.
find quote