Reply to thread

Message: <blockquote data-quote="mm1352000" data-source="post: 1084386" data-attributes="member: 82144">1. Install MySQL Workbench.[ATTACH=full]151125[/ATTACH]2. Server administration, users and privileges section, server access management tab (you will need to enter root user password which you would have set during install).[ATTACH=full]151127[/ATTACH]3. Click "add account" at the bottom (or you could just select an existing user to modify).Enter any name you like (I choose "mediaportal").Standard authentication type.Limit connectivity to hosts matching: I usually use "%" for any host, but you can enter a comma separated list of host names or IP addresses if you want restrictive security.Enter and confirm password (not necessary if modifying an existing user), then click "apply".4. Switch to the schema privileges tab.Select your chosen user on the left and click "add entry...".[ATTACH=full]151128[/ATTACH]Here you can set privileges per host. For most people using MySQL for MediaPortal this is unnecessary.I select "any host".Hopefully the schema options are self explanatory. In this case your MediaPortal schema does not exist yet, so either use "any schema" (not recommended) or enter the schema name you'd like to use in "schemas matching pattern or name". Note that the default MP TV Server schema name is MpTvDb.When you're done, click "OK".5. Back in the schema privileges tab, select your new entry then click "select all" and save.[ATTACH=full]151129[/ATTACH]6. Repeat step 4 but this time select the "mysql" schema .7. Repeat step 5 but this time tick only SELECT.You've now configured MySQL successfully. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" />When you try to open TV Server configuration again you should expect to get the database configuration dialog:<a href="http://attachments.team-mediaportal.com/2011/01/132425_Mysql.jpg" target="_blank">http://attachments.team-mediaportal.com/2011/01/132425_Mysql.jpg</a>Enter the IP address of the PC on which you installed MySQL. Ideally this IP address should be static. If it isn't, use the PC's hostname.Dependency should be the name of the MySQL service in Windows service managment. Default for MySQL 5.x is MySQL5 (but that may have been changed during install).Schema name can be whatever you like, but it must match the name you selected at step 4 above (otherwise just redo step 4 and 5 above).User name and password should be the details you entered at step 3 above.Now click "test"... and hopefully everything goes green. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" />If it doesn't:<ul> <li data-xf-list-type="ul">MySQL is not running OR</li> <li data-xf-list-type="ul">firewall is blocking access (TVService.exe and SetupTv.exe need permission to use your network) OR</li> <li data-xf-list-type="ul">you've made a mistake in MySQL configuration OR</li> <li data-xf-list-type="ul">you've made a mistake in the info in the DB dialog</li> </ul>Assuming test worked, save... and now TV Server configuration should start.</blockquote>

Verification