TVServer / MySQL Password Recovery (2 Viewers)

[Chuckyy]

TV-Server Version: 1.0.2
MediaPortal Version: 1.0.2
MediaPortal Skin: StreamedMP
Windows Version: Vista Home Premium 32bit
CPU Type: Intel 8400
HDD: Seagate 250 gig
Memory: 2 gig GeIl
Motherboard: Fn33
Video Card: ati 3450
Video Card Driver: catalyst
Sound Card: onboard intel stuff
TV - HTPC Connection: SingleSeat




So, here's my story:

I updated to Mediaportal 1.0.2. Everythings fine, except TV. Mediaportal said, it can't connect to TVServer. Ok, opening up TVServer config showed that my password to the MySQL 5 database got lost.

I forgot my password. No big deal. Google for "mysql password reset". Found sth., applied it and IT Worked! I can now connect to the Database via login per Command-Line, which I couldn't beforehand.

The TVServer Wizard doesn't agree. Still says any connection is refused! Why?

How does TVServer Config connect to the database? Do I have to change the pw on a "per-database"-basis?


Note: I read the Wiki, it said reinstall Mediaportal. I went through the process. I guess nothing was installed (no bars indicating an installation). Error didn't go away.

I know that most probably reinstalling MySQL will fix the issue but, then my Config gets lost....

Thanks for reading.

Greetz, Chucky

 

[neo2001]

I forgot my password. No big deal. Google for "mysql password reset". Found sth., applied it and IT Worked! I can now connect to the Database via login per Command-Line, which I couldn't beforehand.

The TVServer Wizard doesn't agree. Still says any connection is refused! Why?

Maybe you could try the MySQL Administrator Tool to check permissions: MySQL :: MySQL GUI Tools Downloads

I'm not very familiar with MP TVS using MySQL, only with MySQL itself. How exactly did you reset the password? As far as I know the root-Account has always full permissions on all databases. But maybe the root-Account you changed is only for local authentication, but (as far as i know) MPTVS is connecting via a network socket. Or the new password is plain text and not encrypted....

 

[Chuckyy]

Hey,

right i totally forgot about mysql administration. i thought about mysql-admin, but was too lazy to set up an apache....

I'll give your tool a try.

What I did was, replacing the my.ini and starting the mysql service with an .ini which only containned the command to reset the root password. I did it twice, because of the local-authentication, you mentioned.

First: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

Second: SET PASSWORD FOR 'root'@'MyWorkstation' = PASSWORD('MyNewPassword');

Greetz, Chuckyy

Hi,

I changed the password via MySQL Administrator and now i can connect with TVServer.

Thanks a lot.

Chuckyy