HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker
(2012-04-07, 15:51)Finchy Wrote: OK, so thid is the process I have used;

Pre installation;

Network shares on WHS for the media folders set up, read/write access given to all relevant users and Homegroup users. Control checked by creating and deleting dummy files form another PC on the LAN.
Network share set up for XBMCthumbs with full read/write permissions.

MySQL installation;
Installed MySQL on WHS2011 via the Windows WPI installer (MySQL v 5.1)
Ran the config with standard installtion, set admin password, did not tick 'allow root access from remote machines'.
Added "skip-name-resolve" to the Mysqld section of the 'my.ini' file.
Changed the MySQL service to log on with the local administrator, stopped and restarted the service.
Added incoming and outgoing firewall access rules for port 3306 for domain and private connections.

MySQL XBMC setup;
Open up MySQL command line client and created the xbmc user and DB;
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;
GRANT ALL ON *.* TO 'xbmc';

At this point should I not be able to test the MySQL DB from another PC on the network for connection? I'm trying to connect with SQLyog and MySQL Workbench from my laptop using the IP and XBMC username/password but it's not connecting. I can however connect to it from SQLyog on the WHS as both root and XBMC, but when I check the user priveledges in there it doesn't have any for XBMC on the xbmc_video or xbmc_music databases, and if I try to add them it gives me a 1044 error.

Do I need to do anything else to the settings/priveledges in MySQL, and if so, how?

Also, for clarification, I have an ATV2 and a Windows 7 PC that I want to connect to the SQL server, although I'm looking at installing XBMCbuntu on the Win 7 PC. Do I need to open the firewall for the Win 7 client as well?

Try running this as root:

grant all on *.* to 'xbmc'@'%' identified by 'yourpassword';



Messages In This Thread
[No subject] - by Flomaster - 2010-09-10, 19:50
[No subject] - by lloydsmart - 2010-09-10, 20:53
[No subject] - by avus m3 - 2010-09-10, 22:30
[No subject] - by skunobe - 2010-09-10, 22:44
[No subject] - by kophinos - 2010-09-12, 21:15
[No subject] - by PreviousN - 2010-09-17, 17:05
[No subject] - by bcboncs - 2010-09-17, 18:05
[No subject] - by mjjstorey - 2010-09-18, 13:37
[No subject] - by Ogi010 - 2010-10-05, 05:36
[No subject] - by Nick8888 - 2010-10-05, 05:46
[No subject] - by avus m3 - 2010-10-05, 09:30
[No subject] - by Cirion - 2010-10-08, 09:28
[No subject] - by ederson - 2010-10-15, 19:41
[No subject] - by ederson - 2010-10-16, 13:12
[No subject] - by aeiah - 2010-10-20, 16:34
[No subject] - by Magua - 2010-10-20, 21:39
library update problem - by Magua - 2010-10-20, 21:42
[No subject] - by enoklinger - 2010-10-21, 21:47
[No subject] - by opensauce - 2010-10-22, 01:53
[No subject] - by enoklinger - 2010-10-22, 02:44
[No subject] - by mcoto - 2010-10-24, 18:08
[No subject] - by Cirion - 2010-10-25, 10:03
[No subject] - by weedenbc - 2010-10-31, 14:24
Sorry if this is the wrong place - by jwdv22 - 2010-11-04, 23:03
[No subject] - by hitman - 2010-11-05, 10:12
[No subject] - by jwdv22 - 2010-11-05, 15:31
[No subject] - by jwdv22 - 2010-11-05, 20:20
[No subject] - by PasiZ - 2010-11-10, 23:21
[No subject] - by Cirion - 2010-11-12, 13:10
[No subject] - by Croaker - 2010-11-12, 14:59
[No subject] - by hitman - 2010-11-12, 17:40
[No subject] - by Croaker - 2010-11-15, 15:58
[No subject] - by PasiZ - 2010-11-16, 10:28
[No subject] - by weedenbc - 2010-11-18, 04:02
[No subject] - by PasiZ - 2010-11-18, 08:57
[No subject] - by PasiZ - 2010-11-18, 08:58
[No subject] - by Croaker - 2010-11-21, 17:35
[No subject] - by Thermos - 2010-11-22, 02:20
[No subject] - by Ram2000 - 2010-11-27, 23:03
[No subject] - by Thermos - 2010-11-28, 20:11
[No subject] - by Ram2000 - 2010-11-28, 23:33
[No subject] - by Thermos - 2010-12-05, 06:12
Library Mode working - by Def_Proc - 2010-12-07, 21:03
[No subject] - by ant_thomas - 2010-12-07, 22:16
[No subject] - by ^FrEaK^ - 2010-12-11, 12:42
[No subject] - by avus m3 - 2010-12-12, 00:54
[No subject] - by ^FrEaK^ - 2010-12-12, 14:02
[No subject] - by pig13t - 2010-12-12, 16:03
[No subject] - by pig13t - 2010-12-12, 18:44
[No subject] - by grongs - 2010-12-13, 11:34
[No subject] - by Ram2000 - 2010-12-14, 22:25
[No subject] - by castortray - 2010-12-17, 23:24
[No subject] - by PasiZ - 2010-12-18, 12:56
[No subject] - by PasiZ - 2010-12-18, 12:57
[No subject] - by Cash - 2010-12-21, 03:06
[No subject] - by ^FrEaK^ - 2010-12-21, 18:04
[No subject] - by Cash - 2010-12-21, 23:17
[No subject] - by ^FrEaK^ - 2010-12-22, 09:43
[No subject] - by ^FrEaK^ - 2010-12-22, 22:27
[No subject] - by chrissbu - 2010-12-26, 15:01
[No subject] - by ^FrEaK^ - 2010-12-27, 01:20
[No subject] - by ^FrEaK^ - 2010-12-27, 01:22
[No subject] - by macshield - 2010-12-28, 22:35
[No subject] - by wicked_n_raw - 2011-01-01, 21:03
No XBMC on WHS - by czfj5r - 2011-01-02, 01:27
[No subject] - by wicked_n_raw - 2011-01-02, 05:16
[No subject] - by wicked_n_raw - 2011-01-02, 09:43
[No subject] - by ^FrEaK^ - 2011-01-02, 11:49
[No subject] - by czfj5r - 2011-01-02, 18:28
[No subject] - by wicked_n_raw - 2011-01-02, 20:49
[No subject] - by wicked_n_raw - 2011-01-03, 05:58
[No subject] - by tboooe - 2011-01-03, 06:18
\ vs / ? - by czfj5r - 2011-01-03, 11:09
[No subject] - by wicked_n_raw - 2011-01-03, 16:13
[No subject] - by rcoops - 2011-01-03, 17:29
[No subject] - by rcoops - 2011-01-03, 23:03
Can't add videos to library - by tboooe - 2011-01-03, 23:51
[No subject] - by bluenote - 2011-01-13, 08:07
[No subject] - by alexxxo - 2011-01-19, 14:47
[No subject] - by castortray - 2011-01-23, 01:26
[No subject] - by clambert - 2011-01-28, 23:22
[No subject] - by NickSoapdish - 2011-02-01, 21:50
[No subject] - by clambert - 2011-02-02, 00:21
[No subject] - by NickSoapdish - 2011-02-02, 03:45
[No subject] - by clambert - 2011-02-02, 03:53
[No subject] - by NickSoapdish - 2011-02-02, 03:58
[No subject] - by clambert - 2011-02-02, 04:15
[No subject] - by NickSoapdish - 2011-02-03, 02:56
[No subject] - by clambert - 2011-02-03, 03:06
[No subject] - by IAmNotAUser - 2011-02-03, 12:21
[No subject] - by NickSoapdish - 2011-02-03, 21:17
[No subject] - by clambert - 2011-02-04, 23:04
[No subject] - by ^FrEaK^ - 2011-02-05, 21:06
[No subject] - by tboooe - 2011-02-05, 21:20
[No subject] - by twotone8 - 2011-02-06, 04:59
[No subject] - by panaman - 2011-02-06, 07:01
[No subject] - by ^FrEaK^ - 2011-02-06, 11:51
[No subject] - by NickSoapdish - 2011-02-07, 15:46
Music fanart not showing up - by tboooe - 2011-02-07, 18:04
[No subject] - by paco - 2011-02-08, 07:01
[No subject] - by NickSoapdish - 2011-02-09, 00:00
[No subject] - by tboooe - 2011-02-09, 01:44
[No subject] - by paco - 2011-02-09, 07:26
[No subject] - by Hudson_Hawk04 - 2011-02-10, 23:06
[No subject] - by clambert - 2011-02-10, 23:14
[No subject] - by Hudson_Hawk04 - 2011-02-11, 03:35
[No subject] - by svenh - 2011-02-12, 05:40
[No subject] - by Emohawk - 2011-02-13, 14:19
[No subject] - by Hudson_Hawk04 - 2011-02-13, 16:18
[No subject] - by Emohawk - 2011-02-13, 18:11
[No subject] - by cptjsparrow7 - 2011-02-14, 08:07
[No subject] - by Hudson_Hawk04 - 2011-02-14, 23:26
[No subject] - by castortray - 2011-02-18, 10:02
[No subject] - by Hudson_Hawk04 - 2011-02-18, 19:21
[No subject] - by Kewlj1313 - 2011-02-19, 18:19
[No subject] - by Kewlj1313 - 2011-02-19, 18:19
[No subject] - by tboooe - 2011-02-19, 18:46
[No subject] - by castortray - 2011-02-20, 22:57
[No subject] - by TugboatBill - 2011-02-23, 22:22
[No subject] - by clambert - 2011-02-23, 22:24
[No subject] - by TugboatBill - 2011-02-24, 01:33
It works! - by cptjsparrow7 - 2011-02-25, 18:59
[No subject] - by NoPantsJim - 2011-02-27, 19:02
[No subject] - by TugboatBill - 2011-02-27, 19:18
[No subject] - by NoPantsJim - 2011-02-27, 19:27
[No subject] - by svenh - 2011-03-01, 00:46
[No subject] - by P_Jamula - 2011-03-22, 08:27
[No subject] - by P_Jamula - 2011-03-25, 07:57
[No subject] - by tboooe - 2011-03-25, 16:22
[No subject] - by P_Jamula - 2011-03-26, 08:02
[No subject] - by labtopia - 2011-04-03, 15:52
[No subject] - by clambert - 2011-04-03, 16:20
Thank you so much for this - by akira6968 - 2011-04-08, 13:44
[No subject] - by pumkinut - 2011-04-10, 00:04
[No subject] - by attilag78 - 2011-04-10, 05:06
[No subject] - by evanl81 - 2011-04-30, 03:29
[No subject] - by xypus - 2011-04-30, 11:52
[No subject] - by no_Legend - 2011-05-01, 15:58
[No subject] - by Xenomes - 2011-05-06, 09:31
[No subject] - by Thibaultvdb - 2011-05-12, 20:58
[No subject] - by TugboatBill - 2011-05-12, 22:04
[No subject] - by Xenomes - 2011-05-13, 13:58
[No subject] - by aptalca - 2011-05-13, 19:11
[No subject] - by Xenomes - 2011-05-16, 10:16
[No subject] - by orons - 2011-05-16, 10:24
[No subject] - by Xenomes - 2011-05-16, 10:33
[No subject] - by clambert - 2011-05-16, 12:53
[No subject] - by aptalca - 2011-05-17, 00:17
[No subject] - by clambert - 2011-05-17, 01:42
[No subject] - by deefortyone - 2011-05-29, 08:51
[No subject] - by tboooe - 2011-05-29, 14:32
[No subject] - by mdewyer - 2011-06-01, 23:05
[No subject] - by mwkurt - 2011-06-02, 16:55
[No subject] - by mdewyer - 2011-06-02, 19:37
[No subject] - by mwkurt - 2011-06-02, 20:19
[No subject] - by mdewyer - 2011-06-02, 20:53
[No subject] - by mwkurt - 2011-06-03, 12:05
[No subject] - by HarryRosen - 2011-06-11, 12:55
[No subject] - by HarryRosen - 2011-06-13, 05:31
[No subject] - by jtheilbrun - 2011-06-13, 19:14
[No subject] - by Xenomes - 2011-06-17, 11:44
[No subject] - by clambert - 2011-06-17, 13:15
[No subject] - by clambert - 2011-06-19, 07:54
[No subject] - by reksveks - 2011-06-19, 12:02
[No subject] - by thadiyan - 2011-06-20, 04:08
[No subject] - by clambert - 2011-06-20, 04:23
[No subject] - by thadiyan - 2011-06-20, 13:30
[No subject] - by Sparhawk1995 - 2011-06-23, 02:56
[No subject] - by mrdally204 - 2011-06-24, 11:17
[No subject] - by reblutus - 2011-06-24, 20:32
[No subject] - by sbentin - 2011-06-25, 19:10
[No subject] - by thadiyan - 2011-06-25, 19:50
[No subject] - by Jete246 - 2011-06-26, 20:25
[No subject] - by sbentin - 2011-06-26, 20:49
[No subject] - by Jete246 - 2011-06-26, 21:14
[No subject] - by sbentin - 2011-06-26, 21:19
[No subject] - by Jete246 - 2011-06-26, 22:28
[No subject] - by mrdally204 - 2011-06-27, 00:56
[No subject] - by Jete246 - 2011-06-27, 09:22
[No subject] - by mrdally204 - 2011-06-28, 09:20
[No subject] - by hitman - 2011-06-28, 10:27
[No subject] - by Jete246 - 2011-06-28, 10:31
[No subject] - by mrdally204 - 2011-06-28, 20:16
[No subject] - by gyrene2083 - 2011-06-28, 20:51
[No subject] - by Jete246 - 2011-06-28, 21:25
[No subject] - by RockDawg - 2011-06-28, 22:26
[No subject] - by mrdally204 - 2011-06-29, 03:49
[No subject] - by gyrene2083 - 2011-06-29, 04:01
symlink help needed - by hori - 2011-06-29, 08:30
[No subject] - by Jete246 - 2011-06-29, 11:05
[No subject] - by mrdally204 - 2011-06-29, 11:42
[No subject] - by Jete246 - 2011-06-29, 11:50
[No subject] - by Jete246 - 2011-06-29, 11:57
[No subject] - by mrdally204 - 2011-06-29, 12:10
[No subject] - by NorDemoniac - 2011-06-29, 12:20
[No subject] - by RockDawg - 2011-06-29, 14:23
[No subject] - by NorDemoniac - 2011-06-29, 14:35
[No subject] - by RockDawg - 2011-06-29, 14:55
[No subject] - by NorDemoniac - 2011-06-29, 15:18
[No subject] - by NorDemoniac - 2011-06-30, 10:42
[No subject] - by kiboy6 - 2011-07-05, 10:30
[No subject] - by clambert - 2011-07-05, 13:38
[No subject] - by Xenomes - 2011-07-06, 16:14
[No subject] - by svenh - 2011-07-09, 05:09
[No subject] - by tboooe - 2011-07-09, 16:01
[No subject] - by svenh - 2011-07-11, 21:58
[No subject] - by PetSue - 2011-07-13, 09:46
[No subject] - by PetSue - 2011-07-16, 07:33
[No subject] - by mrdally204 - 2011-07-16, 08:54
[No subject] - by PetSue - 2011-07-16, 09:36
[No subject] - by gabbott - 2011-08-14, 17:43
[No subject] - by ederson - 2011-08-17, 10:30
[No subject] - by gabbott - 2011-08-17, 15:57
[No subject] - by aptalca - 2011-08-17, 17:05
[No subject] - by svenh - 2011-08-17, 21:18
[No subject] - by aptalca - 2011-08-17, 21:42
[No subject] - by svenh - 2011-08-18, 02:47
[No subject] - by ederson - 2011-08-18, 19:47
[No subject] - by aptalca - 2011-08-19, 18:00
[No subject] - by smiffy1989 - 2011-08-20, 22:21
[No subject] - by elmerohueso - 2011-08-21, 05:54
[No subject] - by ederson - 2011-08-21, 16:29
[No subject] - by aptalca - 2011-08-21, 22:07
[No subject] - by phsyraxion - 2011-08-22, 07:12
[No subject] - by gabbott - 2011-08-22, 16:21
[No subject] - by Headcase_Fargon - 2011-08-24, 17:11
[No subject] - by phsyraxion - 2011-08-25, 03:00
[No subject] - by phsyraxion - 2011-08-26, 00:41
[No subject] - by Hyram - 2011-09-06, 22:44
[No subject] - by Methanoid - 2011-09-17, 21:08
[No subject] - by hyperlink - 2011-09-23, 21:03
[No subject] - by StanLee - 2011-09-25, 22:28
[No subject] - by scooper750 - 2011-09-27, 17:17
[No subject] - by scooper750 - 2011-09-27, 17:21
[No subject] - by SophT - 2011-10-04, 06:59
[No subject] - by constrictor - 2011-10-05, 19:49
[No subject] - by Kolkjaer - 2011-10-15, 17:58
[No subject] - by Tobas - 2011-10-16, 09:31
[No subject] - by daninino - 2011-10-26, 10:14
[No subject] - by Ray_N - 2011-10-27, 23:34
[No subject] - by nchall - 2011-10-28, 07:32
[No subject] - by DrGosha - 2011-11-01, 12:34
[No subject] - by jacintech.fire - 2011-11-01, 16:17
[No subject] - by Ray_N - 2011-11-01, 17:15
[No subject] - by DrGosha - 2011-11-01, 23:09
[No subject] - by Ray_N - 2011-11-01, 23:35
[No subject] - by DrGosha - 2011-11-02, 00:45
[No subject] - by devilshaven - 2011-11-02, 06:26
[No subject] - by DrGosha - 2011-11-03, 02:30
[No subject] - by devilshaven - 2011-11-03, 05:27
[No subject] - by rcloud - 2011-11-05, 00:42
[No subject] - by devilshaven - 2011-11-05, 19:45
[No subject] - by Ray_N - 2011-11-06, 04:10
[No subject] - by rcloud - 2011-11-06, 05:48
[No subject] - by Finchy - 2011-11-10, 10:16
[No subject] - by jwdv22 - 2011-11-10, 16:07
[No subject] - by dsimages - 2011-11-10, 22:46
[No subject] - by Finchy - 2011-11-11, 00:20
[No subject] - by Darkcloud - 2011-11-13, 09:49
[No subject] - by Klyde - 2011-11-13, 23:07
[No subject] - by Ned Scott - 2011-11-14, 08:39
[No subject] - by darkscout - 2011-11-14, 09:04
[No subject] - by Fruitfly - 2011-11-16, 03:55
[No subject] - by darkscout - 2011-11-16, 04:48
[No subject] - by Fruitfly - 2011-11-16, 10:18
[No subject] - by Xsabre - 2011-11-16, 16:14
[No subject] - by Fruitfly - 2011-11-16, 17:35
[No subject] - by Fruitfly - 2011-11-16, 17:48
[No subject] - by darkscout - 2011-11-16, 18:17
[No subject] - by Fruitfly - 2011-11-16, 19:32
[No subject] - by darkscout - 2011-11-16, 19:38
[No subject] - by Klyde - 2011-11-17, 16:15
[No subject] - by darkscout - 2011-11-17, 16:30
[No subject] - by Klyde - 2011-11-17, 17:05
[No subject] - by darkscout - 2011-11-17, 18:10
[No subject] - by Klyde - 2011-11-17, 20:41
[No subject] - by darkscout - 2011-11-17, 23:36
[No subject] - by Finchy - 2011-11-25, 23:16
[No subject] - by darkscout - 2011-11-26, 01:53
[No subject] - by Finchy - 2011-11-26, 03:30
[No subject] - by darkscout - 2011-11-26, 03:46
[No subject] - by Methanoid - 2011-11-26, 12:36
[No subject] - by Finchy - 2011-11-26, 16:56
[No subject] - by darkscout - 2011-11-26, 18:10
[No subject] - by Finchy - 2011-11-26, 22:24
[No subject] - by Finchy - 2011-11-26, 23:53
[No subject] - by Finchy - 2011-11-27, 00:27
[No subject] - by Finchy - 2011-11-27, 17:26
[No subject] - by chrissbu - 2011-12-13, 04:10
[No subject] - by Finchy - 2011-12-13, 09:45
[No subject] - by Klyde - 2012-01-04, 04:18
[No subject] - by silencery - 2012-01-04, 06:49
[No subject] - by jwdv22 - 2012-01-04, 16:35
[No subject] - by jwdv22 - 2012-01-04, 17:23
[No subject] - by EMETIB - 2012-01-10, 00:10
[No subject] - by {{INX}} - 2012-01-10, 15:50
[No subject] - by {{INX}} - 2012-01-10, 20:49
[No subject] - by Klyde - 2012-01-11, 00:44
[No subject] - by hjid - 2012-01-11, 21:58
[No subject] - by Ray_N - 2012-01-11, 22:03
[No subject] - by hjid - 2012-01-11, 22:51
[No subject] - by jdoggvt - 2012-01-11, 22:59
[No subject] - by bill55 - 2012-01-12, 18:13
[No subject] - by bill55 - 2012-01-13, 04:20
[No subject] - by {{INX}} - 2012-01-13, 20:45
[No subject] - by TeKo - 2012-01-14, 01:43
[No subject] - by {{INX}} - 2012-01-14, 04:51
[No subject] - by TeKo - 2012-01-14, 05:10
[No subject] - by {{INX}} - 2012-01-14, 11:47
[No subject] - by TeKo - 2012-01-14, 17:22
[No subject] - by Blaxxor - 2012-01-19, 21:29
[No subject] - by kmusk01 - 2012-01-24, 17:59
[No subject] - by kmusk01 - 2012-01-26, 20:37
[No subject] - by Dam0 - 2012-01-27, 12:33
[No subject] - by Betard - 2012-01-29, 19:46
[No subject] - by jwdv22 - 2012-01-30, 15:19
[No subject] - by kmusk01 - 2012-01-30, 16:20
[No subject] - by Ned Scott - 2012-01-30, 21:36
[No subject] - by Ned Scott - 2012-01-30, 21:47
[No subject] - by Blaxxor - 2012-01-31, 09:05
[No subject] - by kri kri - 2012-02-01, 21:11
[No subject] - by Ned Scott - 2012-02-02, 07:39
[No subject] - by Jedfordski - 2012-02-05, 10:41
[No subject] - by Ned Scott - 2012-02-06, 06:20
CWinFileSMB Error - by mholzma - 2012-02-09, 04:14
[No subject] - by macrossmaxim - 2012-02-09, 04:46
[No subject] - by malibu327 - 2012-02-09, 06:58
[No subject] - by Ned Scott - 2012-02-09, 22:19
[No subject] - by mattdamon - 2012-02-10, 00:19
[No subject] - by mattdamon - 2012-02-10, 00:25
[No subject] - by Ned Scott - 2012-02-10, 00:59
[No subject] - by mattdamon - 2012-02-10, 10:14
[No subject] - by snoopy78 - 2012-02-10, 19:32
[No subject] - by Herkatus - 2012-02-11, 13:27
[No subject] - by Herkatus - 2012-02-11, 16:43
[No subject] - by gabbott - 2012-02-11, 17:27
[No subject] - by sbalani - 2012-02-18, 18:53
[No subject] - by Necochino - 2012-02-19, 02:33
How does this work in Eden Beta 3 - by frr792 - 2012-02-22, 04:12
Setting up MYSQL on OSX - by tdhz77 - 2012-02-23, 14:02
[No subject] - by mikeprep - 2012-03-05, 12:08
[No subject] - by Ned Scott - 2012-03-06, 03:31
[No subject] - by impmonkey - 2012-03-07, 04:03
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - by noner - 2012-04-07, 19:58
Don't use MySQL 5.6 - by Squigibo - 2013-02-23, 20:46
Please close thread - by Ray_N - 2013-02-25, 20:06
Logout Mark Read Team Forum Stats Members Help
HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker1