Access denied when testing MySQL connection

snr_duck · 2008-08-21, 12:29

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 · 2008-08-21, 22:57

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 · 2008-08-22, 10:55

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 · 2008-08-22, 11:50

Quote:

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

PEBKAC

2008-08-21, 12:29	#1 (permalink)
snr_duck Portal Member Join Date: Apr 2006 Posts: 30 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Access denied when testing MySQL connection 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 ? __________________ My HTPC Rig Asus P5Q with E2180 @ 2.2Ghz 2GB PC6400 Dual Channel DDR2 NVidia 8500GT and Compro DVB-T300 Drives: 3x500GB 1x160GB 2x250GB XP Pro + Media Portal 1.0 RC2 Last edited by snr_duck; 2008-08-21 at 13:15.

2008-08-22, 10:55	#3 (permalink)
snr_duck Portal Member Join Date: Apr 2006 Posts: 30 Thanks: 0 Thanked 0 Times in 0 Posts Country:	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. __________________ My HTPC Rig Asus P5Q with E2180 @ 2.2Ghz 2GB PC6400 Dual Channel DDR2 NVidia 8500GT and Compro DVB-T300 Drives: 3x500GB 1x160GB 2x250GB XP Pro + Media Portal 1.0 RC2

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL connection not allowed when using TV Server Configuration utility	DugieHowsa	1.0 RC2 and SVN Builds	4	2008-09-16 23:04
MySQL without granting root access	noonereallycares	Installation, configuration support	2	2008-07-31 14:42
A request to suspend power was denied by DW20.EXE	riadmelb	General Support	2	2008-07-03 01:19
Help us testing the new TsWriter	gemx	Development	187	2008-02-27 22:48
Need help testing	igalan	MyTV - Engine 0.2	4	2007-11-21 10:55

2008-08-21, 22:57	#2 (permalink)
Hugo Portal Member Join Date: Jul 2006 Posts: 49 Thanks: 0 Thanked 0 Times in 0 Posts	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...