+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Announcements, Info, and General Discussion (/forumdisplay.php?fid=85)
+--- Forum: Tips, tricks, and step by step guides (/forumdisplay.php?fid=110)
+--- Thread: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker (/showthread.php?tid=80829)
- Ned Scott - 2011-11-14 08:39
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.
- darkscout - 2011-11-14 09:04
Now the problem: How do we get the internet to take down old information?
- Fruitfly - 2011-11-16 03:55
Is anyone having the same problem as me and solved it?
I followed everything in lifehacker.
I installed the latest XBMC Dharma,
Installed MYSQL, typed in the first command prompt shown in lifehacker.
which was
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
then this error came up:
ERROR 1396 (HY000): Operation CREATE USER failed for 'xbmc'@'%'
I tried running as administrator. Tried google, still can't find an answer.
I'm running windows 7 64-bit
4gb Ram
AMD X6
Geforce GTX 570
if that helps
please help me
- darkscout - 2011-11-16 04:48
Fruitfly Wrote:then this error came up:
ERROR 1396 (HY000): Operation CREATE USER failed for 'xbmc'@'%'
You logged into the mysql server as root?
Else search google. This is a mysql error, not an XBMC error.
- Fruitfly - 2011-11-16 10:18
yeap, logged in as root, ran as administrator. Still the same.
- Xsabre - 2011-11-16 16:14
Fruitfly Wrote:CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
then this error came up:
ERROR 1396 (HY000): Operation CREATE USER failed for 'xbmc'@'%'
Going to make my first post count...
I don't know a thing about MySQL. But I had the same problem. Issues stems from which character is used "`" (located next to the 1 on the keyboard) verse " ' " (located...next to enter). I don't understand the syntax well enough. But follow the syntax below...
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
Notice the different character before and after `xbmc_%`. verse 'xbmc'@'%'.
I have been try to get synchronizing multiple XBMC with nightly for over a week without luck. I keep telling myself to wait for final. But I can't let it go. I have learn quite a few things about MySQL in the last few days. Which I see as a plus
- Fruitfly - 2011-11-16 17:35
Nope didn't work,
Says here
ERROR 1046 (3D000): No database selected,
Also how do you log in as root?
- Fruitfly - 2011-11-16 17:48
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
- darkscout - 2011-11-16 18:17
BECAUSE IT'S ALREADY CREATED.
Just apply the proper permissions and be done with it.
- Fruitfly - 2011-11-16 19:32
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?