Solved Issue - Issues / Errors setting up MySQL install for Windows and centralized XBMC SQL Dbase

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
transcender Offline
Donor
Posts: 233
Joined: Mar 2010
Reputation: 2
Post: #1
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
http://www.contentwhores.com/wordpress/?page_id=432
http://lifehacker.com/5634515/how-to-syn...eedfetcher

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.

Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
(This post was last modified: 2014-01-03 00:59 by transcender.)
find quote
transcender Offline
Donor
Posts: 233
Joined: Mar 2010
Reputation: 2
Post: #2
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 [1042](Can't get hostname for your address)

Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
find quote
TugboatBill Offline
Posting Freak
Posts: 829
Joined: Oct 2009
Reputation: 7
Post: #3
Try using the IP address instead.
find quote
transcender Offline
Donor
Posts: 233
Joined: Mar 2010
Reputation: 2
Post: #4
I was using IPs.
I found some DNS configuration in SQL even though using IPs. weird. looks like i'm up now.

Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
find quote