Reply to thread

Message

<blockquote data-quote="SpudR" data-source="post: 1178139" data-attributes="member: 54104">Just to add to this = I removed the mySQL 5.7 version like this:Admin command prompt (<ul>
<li data-xf-list-type="ul">net stop mysql</li>
<li data-xf-list-type="ul">sc delete mysql</li>
<li data-xf-list-type="ul">exit</li>
</ul>Manually delete<ul>
<li data-xf-list-type="ul">C:\program files\mysql\[server folder]</li>
<li data-xf-list-type="ul">C:\programdata\mysql\[server folder]</li>
</ul>REBOOT &lt; This is VERY important!Run the deploy tool againDownload onlyGrab the componentsRun the mySQL installerAdmin command prompt<ul>
<li data-xf-list-type="ul">cd\</li>
<li data-xf-list-type="ul">cd program files\mysql\mysql server 5.6\bin</li>
<li data-xf-list-type="ul">mysqld --install (if you get a warning about time stamps - do it again until you get a 'succeeded' message)</li>
<li data-xf-list-type="ul">net start mysql</li>
</ul>5.6 is now installed and runningRun mySQL workbench (install it if it's not installed)Add a connection (empty password)open a conenction to the server create a new user with these details<ul>
<li data-xf-list-type="ul">User name - root</li>
<li data-xf-list-type="ul">host - [your computer name]</li>
<li data-xf-list-type="ul">password - MediaPortal</li>
<li data-xf-list-type="ul">User role - DBA</li>
</ul>#TIP#You can get your PC name by entering 'hostname' (without the quotes) in to a command prompt.Run the TV server setup thing and the connect to the database app starts - pressing 'test' should make it all go green.You can then change what is required (if anything) using the mySQL Workbench.Now I've just got an issue writing to the music DB (not mysql)Thanks for the help guys!</blockquote>

[QUOTE="SpudR, post: 1178139, member: 54104"] Just to add to this = I removed the mySQL 5.7 version like this: Admin command prompt ( [LIST] [*]net stop mysql [*]sc delete mysql [*]exit [/LIST] Manually delete [LIST] [*]C:\program files\mysql\[server folder] [*]C:\programdata\mysql\[server folder] [/LIST] [B]REBOOT < This is VERY important! [/B] Run the deploy tool again Download only Grab the components Run the mySQL installer Admin command prompt [LIST] [*]cd\ [*]cd program files\mysql\mysql server 5.6\bin [*]mysqld --install (if you get a warning about time stamps - do it again until you get a 'succeeded' message) [*]net start mysql [/LIST] 5.6 is now installed and running Run mySQL workbench (install it if it's not installed) Add a connection (empty password) open a conenction to the server create a new user with these details [LIST] [*]User name - root [*]host - [your computer name] [*]password - MediaPortal [*]User role - DBA [/LIST] #TIP# You can get your PC name by entering 'hostname' (without the quotes) in to a command prompt. Run the TV server setup thing and the connect to the database app starts - pressing 'test' should make it all go green. You can then change what is required (if anything) using the mySQL Workbench. Now I've just got an issue writing to the music DB (not mysql) Thanks for the help guys! [/QUOTE]

Verification