[mythtv-users] still plugging away trying to install mythtv on windows 7

[Vince Coen]

Hi;

Try this:

1.		Disconnect ethernet cable or USB cable from router so that you are not 
connected to the internet in any way.
2.		Double check 1.
3.		Using control panel disable all firewalls.
4.		Try again connecting to mysql.
	A.	If that works go back and reenable firewalls then select / setup mysql port
 		6543 and 3306 to be disabled and try again. If that still does not work you 
have 2 more options:

A2. ***	Have a look at the mysql logs and see if you have a message that 
specifies the reason for the failure to connect.  *** You might want to try 
this first.

A3.		Recheck that you are using the correct password for the database as mine 
is a somewhat more obscured one.

B.  Its not that thenand I'm currently out of ideas but you have tried to 
connect the the DB directly using the same comuter but without using telnet 
ie, use one of the mysql admin tools such as:

Mysqladmin
Phpmyadmin  etc  and see if you can connect to the mysql database engine and 
then for the specific one eg: mythconverg

PS I dont use Win 7 to access the mythtv DB but if you still have a problem, 
let me know and I will attempt to do so (but mythtv runs under Ubuntu Linux) 
but I can get into the mythtv server via my laptop and Win 7.


Vince



On Tuesday 23 Feb 2010, Mark Stewart wrote:
> I installed MySQL GUI v8.2 - and I was able to connect to mythconverg
> database using - port 6543, password mythtv, username mythtv and host
> address - localhost.
> 
> 
> 
> I tried to telnet to localhost 6543 - it said it was connecting (it said
> 5.1.42-community then some gibberish) it finished with - connection to host
> lost.
> 
> 
> 
> I was able to show databases - there were 4 (mythconverg was there) - I
>  told it to use mythconverg.
> 
> 
> 
> I am still getting - Cannot connect to port 6543 on database host localhost
> 
> 
> 
> Please be gentle with me I haven't got a clue how to configure MySQL
> 
> 
> 
> These are the commands I found on the wiki windows page -
> 
>  mysql>create database mythconverg;
> 
>  mysql>GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'  IDENTIFIED BY
> 'mythtv' WITH GRANT OPTION;
> 
>  mysql>GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'%'  IDENTIFIED BY 'mythtv'
> WITH GRANT OPTION;
> 
>  mysql>quit;
> 
> 
> 
> I used these - I think I created a database called mythconverg and a user
> called mythtv?
> 
> 
> 
> Message: 18
> 
> Date: Tue, 23 Feb 2010 13:06:27 -0800
> 
> From: "Kevin Ross" <kevin at familyross.net>
> 
> Subject: Re: [mythtv-users] still trying to install mythtv on windows
> 
>       7
> 
> To: "'Discussion about mythtv'" <mythtv-users at mythtv.org>
> 
> Message-ID: <010e01cab4cc$10f4b0c0$32de1240$@net>
> 
> Content-Type: text/plain;     charset="us-ascii"
> 
> > I installed MySQL GUI v8.2 - and I was able to connect to
> >
> > mythconverg database using - port 6543, password mythtv,
> >
> > username mythtv and host address - localhost.
> 
> I believe the standard TCP port for MySQL is 3306, not 6543.  The
> 
> mythbackend listens on port 6543.  I think you have some port numbers mixed
> 
> up.
> 
> 
> 
> 
> 
> I changed MySQL port 3306 and tried these settings -
> 
> >> Database host name : localhost
> >>
> >> Should I test connectivity : yes
> >>
> >> Database port : 6543
> >>
> >> Database name mythconverg
> >>
> >> Database user name : mythtv
> >>
> >> Database password : mythtv
> >>
> >> Unique identifier : Quad-Core
> >>
> >> Wake-On-Lan no
> >>
> >>
> >>
> >> The error I get is
> >>
> >>
> >>
> >> Cannot connect to port 6543 on database host localhost
> 
> I also tried -
> 
> >> Database host name : localhost
> >>
> >> Should I test connectivity : yes
> >>
> >> Database port : 3306
> >>
> >> Database name mythconverg
> >>
> >> Database user name : mythtv
> >>
> >> Database password : mythtv
> >>
> >> Unique identifier : Quad-Core
> >>
> >> Wake-On-Lan no
> >>
> >>
> >>
> >> The error I get is
> >>
> >>
> >>
> >> Cannot connect to port 3306 on database host localhost
>