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

Mark Stewart ethereal9 at gmail.com
Tue Feb 23 18:15:28 UTC 2010

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


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

 mysql>GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'%'  IDENTIFIED BY 'mythtv'



I used these - I think I created a database called mythconverg and a user
called mythtv?



Message: 15

Date: Mon, 22 Feb 2010 13:50:20 -0800

From: Mark Weil <mark at martialfit.net>

Subject: Re: [mythtv-users] trying to install mythtv on windows 7

To: Discussion about mythtv <mythtv-users at mythtv.org>


      <27887a951002221350r336c4883ma72126e8d8b9b234 at mail.gmail.com>

Content-Type: text/plain; charset="windows-1252"


for mysql connectivity testing you can specify where to connect:

(From a command prompt)



mysql -u <username> -p -h localhost


-u = username

-p = password (it'll prompt you after you press 'Enter') -h = host


you can also specify a database by just tacking it onto the end of the



mysql -u mythtv -p -h localhost mythconverg



and if it's local, you don't need the -h switch;



mysql -u mythtv -p mythconverg



or the database name on the server;



mysql -u mythtv -p



Once at the mysql prompt you can type



show databases;



to display them.

you can



use mythconverg;


show tables;






to exit.


On Mon, Feb 22, 2010 at 1:24 PM, Travis Tabbal <travis at tabbal.net> wrote:




> On Mon, Feb 22, 2010 at 1:59 PM, mark stewart <ethereal9 at gmail.com> wrote:


>> Hello there.


>> I downloaded a binary and installed it along with mysql on my windows 

>> 7 machine.


>> I configured mysql according to this web page 

>> http://www.mythtv.org/wiki/MythTV_on_Windows


>> When I ran the myth backend I used 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


>> The port is open in my router.


>> I don?t know how to troubleshoot this, I don?t know if this is a 

>> mysql problem or a mythtv problem or a router problem.


>> Any help would be  greatly appreciated




> Try using a MySQL client to connect to your database. Have you created 

> the mythconverg database yet? The error is a IP level error, at a CMD 

> prompt, what does "telnet localhost 6543" give you?


> The router doesn't matter, you aren't connecting from the outside. 

> Unless the Windows firewall is blocking your connection? I'm not sure 

> if it does anything with localhost connections as I have never used Win7.


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

More information about the mythtv-users mailing list