Access denied when testing MySQL connection (1 Viewer)

[snr_duck]

TV-Server Version:
MediaPortal Version: 1.0 RC2
MediaPortal Skin: unknown
Windows Version: XP
CPU Type: E2180
HDD: Too many to list
Memory: 2GB Apacer DDR2 800
Motherboard: Asus P5Q
Video Card: 8500GT
Video Card Driver:
Sound Card: Onboard
Sound Card AC3: no AC3
Sound Card Driver:
1. TV Card: Compro DVB-T300
1. TV Card Type: DVB-T
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: Free 2 Air
HTPC Case: Antec P180
Cooling: 3x 120mm fans
Power Supply: Thermal Take 420W
Remote: Compro Silver Remote
TV: Sony 51cm
TV - HTPC Connection: Composite

Hi All...

Just rebuilt my machine and re-installed TV Server + Client but I can't get connected to the MySQL database. I have tried simple as well as complex passwords but I keep getting "Connection Failed #28000Access denied for user 'root'@'pcname.domain.net' (using password :YES)"

I have removed and re-installed MySQL and TV Server several times using default password as well as manual password including basic and complex but still can't get connected.

what am I missing ?


Duck


OK... just went through the very tediuous MySQL manual on resetting the root password. And I have a connection. But WTf went wrong in the install/setup process ?

 

[Hugo]

Perhaps it was just the hostname 'pcname.domain.net'.

In MySQL you can control, from which host/pc a user can connect.

In 'MYSQL Administrator' you can set this - just do a right-click with the
mouse and add the needed host/ip to the user...

 

[snr_duck]

OK... pcname.domain.net is a fictitious rendering of my real hostname.

Obviously I changed this as I use a real domain at home and don't really want every man and his dog hitting every host on my network.

Now I have issues trying to get my WebEPG to work

Things used to be simpler... before I started drinking homebrew.

 

[Paranoid Delusion]

Things used to be simpler... before I started drinking homebrew.

PEBKAC