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

[Mark Stewart]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100223/f8a747c0/attachment.htm>