MySQL Set Password Error on Windows 7 (1 Viewer)

[danzx2]

Hi,

Can someone help me in finding where the hidden files are on Windows 7 to remove to cure this issue?

Thanks
Dan

 

[mm1352000]

Hi danzx2

You can find the TV Server database connection information in the Gentle.config file which is in your TV Server install folder. You can edit the file with any text editor (notepad, wordpad etc.). Look for the following part:

<DefaultProvider name="MySQL" connectionString="Server=YourServerNameHere;Database=MpTvDb;User ID=UserNameIsHere;Password=PasswordIsHere;charset=utf8;Connection Timeout=300;" />

If that doesn't help or wasn't what you were looking for then you really need to explain the problem with more detail - I'm completely guessing here because you haven't given me very much information!

mm

 

[danzx2]

Sorry, I am having an issue when installing MYSQL (when installing MP1.2) as it gives the error 'MySQL Set Password Error 1' and it stops the install. I have deleted the MYSQL folder from Program Files then rebooted but still get the same error. Are any files hidden elsewhere?

Thanks

 

[mm1352000]

Hmm, that's a bit of a strange one - I've never come across anything like this before.

Are you upgrading from MP 1.1.x or 1.2.0a?
Are you running the installer with administrator privileges?

mm

 

[miroslav22]

Hi,

Can someone help me in finding where the hidden files are on Windows 7 to remove to cure this issue?

Thanks
Dan

Hi Dan,

I've had this problem before, I could only solve it by:

Completely uninstalling MySQL (Programs & features -> remove)

Once uninstalled navigate to c:\programdata

There shoud be a MySQL folder in here that holds all your databases/user information. Delete this folder (note you will lose everything MySQL has stored)

Then try re-installing and you should be ok.

 

[danzx2]

Thanks both,

This was following a fresh install of Windows 7. I installed MP1.2 fine but had to recover to a day where it wasn't installed and have had the problem since then. I'll make sure I run it as administrator later

c:\programdata doesn't exist. The MySQL folder is in Program files. I removed this but had the same problem.

 

[Vasilich]

danz, programdata folder marked as hidden, but it always exists in W7.

 

[danzx2]

That will be the issue then. Thanks

 

[miroslav22]

Thanks both,

This was following a fresh install of Windows 7. I installed MP1.2 fine but had to recover to a day where it wasn't installed and have had the problem since then. I'll make sure I run it as administrator later

c:\programdata doesn't exist. The MySQL folder is in Program files. I removed this but had the same problem.

Yea the system restore will trigger the problem as MySql will no longer be installed but the data files for it will still exist. MediaPortal will then not be able to set the password as the data files from the previous install still exist.

As Vasilich says the programdata folder will be there, but you might have to manually key "c:\programdata" into windows explorer's address bar (or enable "Show hidden files & folders")

 

[danzx2]

That did the trick Thanks again