Posts: 31,445
Joined: Jan 2011
2011-11-14, 08:39
(This post was last modified: 2011-11-14, 08:44 by Ned Scott.)
hey all you people, help update/add/improve/whatever to the XBMC Wiki's new from-scratch how-to on this:
HOW-TO:Synchronize multiple XBMC libraries
Just make an account if you don't already have one and start editing.
If you need any help on the wiki or have any questions, feel free to PM me or whatever.
Posts: 2,145
Joined: Jul 2008
Reputation:
12
Now the problem: How do we get the internet to take down old information?
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.
Posts: 7
Joined: Nov 2011
Reputation:
0
yeap, logged in as root, ran as administrator. Still the same.
Posts: 7
Joined: Nov 2011
Reputation:
0
Nope didn't work,
Says here
ERROR 1046 (3D000): No database selected,
Also how do you log in as root?
Posts: 7
Joined: Nov 2011
Reputation:
0
Not sure if this helps
When I type SELECT User, Host, Password FROM MySQL.user;
It shows
A box of 3 users on the first column - root, xbmc, root
And then 3 Host in the next column - localhost, %, %
And passwords on the next
So it seems to me that it is reading xbmc somehow but can't create user
Posts: 2,145
Joined: Jul 2008
Reputation:
12
BECAUSE IT'S ALREADY CREATED.
Just apply the proper permissions and be done with it.
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.
Posts: 7
Joined: Nov 2011
Reputation:
0
Yes Thanks, got the mysql to work.
I did the advancedsettings.xml pasted it in my mac and my windows xbmc userdata folder both with the host's ip address. Didn't change the port. standard 3306 port.
Exported and imported host files to my mac. When import on mac. Nothing came up. Not even that scanning tab on the center top.
Is it actually suppose to auto scan everything to my mac after the whole set up is done?
Posts: 2,145
Joined: Jul 2008
Reputation:
12
You're going to have to rephrase that. You exported. Imported. And nothing is there? What does your debug log say?
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.
Posts: 16
Joined: Nov 2011
Reputation:
0
Klyde
Junior Member
Posts: 16
I'm running into a similiar issue. Since I set this up, both PC's see the same library. But my tv shows when scanned only show the first episode of each season in the library? some of my movies are missing and I'm no longer able to flag media as watched? Any suggestions? Never got any errors with the MYSQL syntax, when I show databases and users they appear to be correct. Once I remove that advancedsettings.xml file from the folder my whole library reappears
Posts: 2,145
Joined: Jul 2008
Reputation:
12
No. That's basically just a dump of your advanced settings file.
We need the whole thing (in a pastebin, do NOT paste it here).
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.