Cannot Configure TV-Server after clean RC2 install (1 Viewer)

[DugieHowsa]

TV-Server Version: 1.0.0.0 RC2
MediaPortal Version: 1.0.0.0 RC2
MediaPortal Skin:
Windows Version: Windows XP Home SP2
CPU Type: Inte; Core2Duo
HDD: 250GB
Memory: 1GB
Motherboard:
Video Card: GeForce 8500GT
Video Card Driver:
Sound Card:
Sound Card AC3:
Sound Card Driver:
1. TV Card: Vista View
1. TV Card Type: Saber DNA-1n1-I
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

I just peformed a fresh install of RC2 with MySQL as the database. After installation completes, I start the TV-Server Utility. After selecting MySQL and entering the password set during installation, I receive the following error:
Connection Failed: Host 'mediapc' is not allowed to connect to this MySQL Server.

Windows firewall is disabled on this machine, and no other firewalls are involved.

the following sreen shots are attached:

firewall disabled
Database Error Message
netstat -an command

 

[DugieHowsa]

Found a fix, but I guess this is a bug in the install. I will file one formally.

https://forum.team-mediaportal.com/...ns-92/mediaportal-silent-installations-38850/

To perform this action, one needs to open a command prompt and browse to the MySQL bin directory. Once there, enter the following commands:

mysql -u root
UPDATE mysql.user SET Password = PASSWORD('mediaportal') WHERE User = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mediaportal';
FLUSH PRIVILEGES;
exit

Then, restart the MySQL server from the command prompt so the new settings can take affect:


net stop mysql
net start mysql

Now, this is good because now I can run the TV Server Config utility, but I am sure this is not the most secure or optimal configuration. I am a novice when it comes to database administration, so I will leave the "tightening up" of this to some one more experienced.

 

[daniel_1980]

Same problem and same solution here.
Anyway, it's not nice hacking commands I don't understand.

 

[Furox]

same here wondering why this happend only at my second rc2 setup!? i guess the reason is that i used the rc1 mysql first but this time did a clean rc2+mysql install..
tried to uninstall mp and mysql and to reboot several times not knowing where the real problem is so

 

[Callumgw]

I've just had the same problem after a fresh install of WinXp SP3 and MP1 RC2...will be trying the 'fix' tonight cheers.

C

 

[Doron]

This probably is indeed a bug. To workaround, it is enough to open "MySQL Command Line Client" from the start menu, and write:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MediaPortal';
FLUSH PRIVILEGES;