Reply to thread

Message

<blockquote data-quote="Lehmden" data-source="post: 991222" data-attributes="member: 109222">Hi.I have set up my new TV Server yesterday. I also tried MySQL 5.6. The Permissions are a bit hard to setup (with default, MP Multiseat clients can't access TV Server). I've added root at % as User (with MySQL Workbench, so it's wise to install it too), then all was working. And I needed to use IP address instead of PC name, as the other way the connection got lost every now and then. This could be an issue of my router, as I had some similar issues earlier (in a complete different circumstance). MySQL Port is blocked from outside my Home network (router- firewall) so no big security problem to allow root access from everywhere... Performance is quite good (= better) compared to MSSQL and especially compared to MySQL 5.1 (average CPU load decreases from 30% on MySQL 5.1 to 2% on MySQL 5.6... ).Did not have any long time experience now, but first impression is good.&nbsp;Ahh,... this is with MP 1.3 final. The 1.4 testbuild (from May 1st) wasn't able to import channels and schedules from export.xml created with 1.3 final so I decided to stay on 1.3 until next build and then try an update...</blockquote>

[QUOTE="Lehmden, post: 991222, member: 109222"] Hi. I have set up my new TV Server yesterday. I also tried MySQL 5.6. The Permissions are a bit hard to setup (with default, MP Multiseat clients can't access TV Server). I've added root at % as User (with MySQL Workbench, so it's wise to install it too), then all was working. And I needed to use IP address instead of PC name, as the other way the connection got lost every now and then. This could be an issue of my router, as I had some similar issues earlier (in a complete different circumstance). MySQL Port is blocked from outside my Home network (router- firewall) so no big security problem to allow root access from everywhere... Performance is quite good (= better) compared to MSSQL and especially compared to MySQL 5.1 (average CPU load decreases from 30% on MySQL 5.1 to 2% on MySQL 5.6... ). Did not have any long time experience now, but first impression is good. Ahh,... this is with MP 1.3 final. The 1.4 testbuild (from May 1st) wasn't able to import channels and schedules from export.xml created with 1.3 final so I decided to stay on 1.3 until next build and then try an update... [/QUOTE]

Verification