Can't install TVService / Connect to MySql (1 Viewer)

[doveman]

I've tried reinstalling, completely uninstalling, rebooting and installing the deploy packages separately and I've got MP 1.6pre installed now but TVService gets to the MySQL connection screen and then fails whatever I set for the machine name/IP address.

I've got MySQL 5.1 and 5.6 installed although Windows Programs and Features only shows 5.6, so should I uninstall that and try reinstalling?

 

[mm1352000]

but TVService gets to the MySQL connection screen and then fails whatever I set for the machine name/IP address.

What do you mean "fails"?

 

[doveman]

It says something like "cannot connect". I checked the MySQL service and that's not running and if I try and start it manually it says "Error 1067: The service terminated unexpectedly".

 

[mm1352000]

Well, blame MySQL then.
If you can, I'd uninstall MySQL and MP and start over.

 

[doveman]

Yeah thanks, that worked. I uninstalled MySQL completely and installed MP1.6 Final and it's OK now

 

[doveman]

Well it didn't last very long!

When booting, I get the following in the System log:

The TVService service depends on the MySQL service which failed to start because of the following error:
The operation completed successfully.

and

The MySQL service terminated unexpectedly. It has done this 1 time(s).

Even if I disable the TVservice and try and start MySQL manually, it fails with "Error 1067: The process terminated unexpectedly".

I realise this is a MySQL problem rather than MediaPortal but has anyone got any ideas why this is happening?

 

[wonkyd]

I suspect that a file that MySQL depends on is possibly corrupt (or the wrong version).

Uninstall MySQL, remove any folders it may have in program files, appdata, programdata and anything it is storing in the registry and try reinstalling it.

 

[doveman]

OK. Last time I uninstalled it and removed all the program files but didn't check the other folders you mention. I wouldn't know where it stores stuff in the registry though. Is there a MySQL cleaner utility that will do all this for me?

 

[regeszter]

Delete all contents from c:\ProgramData\MySQL\ after you uninstall the MySql.