Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 876000" data-attributes="member: 82144">Hello Drizzeh&nbsp;I will try to help. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp;This is what I do when using a pre-installed version of MySQL...&nbsp;1. Create a schema for MP to use. I prefer to do this manually because then security is not so tricky to setup (don't have to give privileges to create schemas). Open workbench and connect to the DB instance (&quot;open connection to start querying&quot;) with a user who has permission to create schemas - root should be fine. Click &quot;add schema&quot; on the left. Enter the name (remember this for later) and select the collation. I usually leave collation as default which corresponds with UTF-8 for me. If you anticipate needing interesting characters in your EPG then you may want to choose a different option.&nbsp;2. Configure MySQL to allow TCP access. Go back to the workbench main menu and configure security for the DB instance (on the right). Go to the &quot;options file&quot; entry on the left, and on the &quot;general&quot; tab ensure that &quot;don't allow connection with TCP/IP&quot; is disabled. I usually also ensure that &quot;enable support for named pipes&quot; is enabled.&nbsp;3. Allow access to the DB user that you will use for MP. Still in security configuration in workbench, go to the &quot;users and privileges&quot; entry on the left, and select the &quot;login&quot; sub-tab on the &quot;server access management&quot; tab. I usually create a dedicated user for MP, and allow access from any host (%). Not using the root user prevents potential remote access with root privileges - a security risk if there is any valuable data in the DB.&nbsp;4. On the &quot;administrative roles&quot; sub-tab I untick everything (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the &quot;account limits&quot; sub-tab I leave everything as zero.&nbsp;5. On the &quot;schema privileges&quot; tab (not sub-tab) I grant &quot;SELECT&quot; on mysql and information_schema from any host to the MP user (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the MediaPortal TV Server schema (whatever you called it in step 1) I enable everything except &quot;GRANT OPTION&quot; from any host. This enables the MP user to do whatever they like with the MP schema, except grant access to another user (which should be unnecessary - just for safety).&nbsp;Now restart the MySQL service and start TV Server configuration.&nbsp;In order from top to bottom, enter:1. The actual IP address or host name of the computer (*not* localhost). It is recommended to use a static IP for the TV Server, so you would enter that IP address (for example 192.168.1.2). If you find static IP addresses confusing or complicated and just want something that works quickly then use the name of the computer. You can find the name by right clicking on any link to &quot;my computer&quot; and selecting properties. The &quot;computer name&quot; shown there is what you should use. Again: I *strongly* recommend using a static IP address. There are plenty of guides available with a quick Google.2. The name of the MySQL service. Usually you don't have to change this.3. The name that you gave to the MP TV Server schema.4. The name of the user that you configured with access to the MP schema.5. The corresponding password for the user.&nbsp;Hopefully everything should work after this. If not, try temporarily turning off firewalls to ensure TV Server configuration is not being blocked from connecting.&nbsp;mm</blockquote>

[QUOTE="mm1352000, post: 876000, member: 82144"] Hello Drizzeh I will try to help. :) This is what I do when using a pre-installed version of MySQL... 1. Create a schema for MP to use. I prefer to do this manually because then security is not so tricky to setup (don't have to give privileges to create schemas). Open workbench and connect to the DB instance ("open connection to start querying") with a user who has permission to create schemas - root should be fine. Click "add schema" on the left. Enter the name (remember this for later) and select the collation. I usually leave collation as default which corresponds with UTF-8 for me. If you anticipate needing interesting characters in your EPG then you may want to choose a different option. 2. Configure MySQL to allow TCP access. Go back to the workbench main menu and configure security for the DB instance (on the right). Go to the "options file" entry on the left, and on the "general" tab ensure that "don't allow connection with TCP/IP" is disabled. I usually also ensure that "enable support for named pipes" is enabled. 3. Allow access to the DB user that you will use for MP. Still in security configuration in workbench, go to the "users and privileges" entry on the left, and select the "login" sub-tab on the "server access management" tab. I usually create a dedicated user for MP, and allow access from any host (%). Not using the root user prevents potential remote access with root privileges - a security risk if there is any valuable data in the DB. 4. On the "administrative roles" sub-tab I untick everything (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the "account limits" sub-tab I leave everything as zero. 5. On the "schema privileges" tab (not sub-tab) I grant "SELECT" on mysql and information_schema from any host to the MP user (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the MediaPortal TV Server schema (whatever you called it in step 1) I enable everything except "GRANT OPTION" from any host. This enables the MP user to do whatever they like with the MP schema, except grant access to another user (which should be unnecessary - just for safety). Now restart the MySQL service and start TV Server configuration. In order from top to bottom, enter: 1. The actual IP address or host name of the computer (*not* localhost). It is recommended to use a static IP for the TV Server, so you would enter that IP address (for example 192.168.1.2). If you find static IP addresses confusing or complicated and just want something that works quickly then use the name of the computer. You can find the name by right clicking on any link to "my computer" and selecting properties. The "computer name" shown there is what you should use. Again: I *strongly* recommend using a static IP address. There are plenty of guides available with a quick Google. 2. The name of the MySQL service. Usually you don't have to change this. 3. The name that you gave to the MP TV Server schema. 4. The name of the user that you configured with access to the MP schema. 5. The corresponding password for the user. Hopefully everything should work after this. If not, try temporarily turning off firewalls to ensure TV Server configuration is not being blocked from connecting. mm [/QUOTE]

Verification