Issues / Errors setting up MySQL install for Windows and centralized XBMC SQL Dbase - Printable Version
+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+--- Thread: Issues / Errors setting up MySQL install for Windows and centralized XBMC SQL Dbase (/showthread.php?tid=93526)
Issues / Errors setting up MySQL install for Windows and centralized XBMC SQL Dbase - transcender - 2011-02-08 05:05
Have a Revo and iPad, would like to get shared/central SQL dbase up.
Having issues w/ MySql install on windows where media storage also resides.
When I follow the link/tutorial from contentwhores.com or lifehacker.com
They gloss over the SQL install which is where my issue is.
During default install, the checkbox is checked to change the root pwrd of dbase. If i try to change / put a pwrd it fails, if blank it fails. If i uncheck the box the install completes.
I can then connect to the dbase as a blank username, but any user such as 'root' fails.
The blank user has no rights so i cant create an 'xbmc' user or anything.
Uncertain issues, i purged the \mysql folder during the uninstall/reinstall attempts.
I did have xampp installed a long time in efforts to get one of the crude early iphone 'remotes' working but it was flaky and i gave up and uninstalled it.
I'm obviously unfamiliar w/ SQL and such appreciate the patience and any insights.
got installed - transcender - 2011-02-08 07:14
but can not get xmbc clients to connect, dbase from workbench looks good.
this is in the log
23:03:20 T:3055253376 M:1428152320 ERROR: Unable to open database: xbmc_music (Can't get hostname for your address)
- TugboatBill - 2011-02-08 18:03
Try using the IP address instead.
- transcender - 2011-02-08 19:02
I was using IPs.
I found some DNS configuration in SQL even though using IPs. weird. looks like i'm up now.