[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
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: 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>
Message-ID:
<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
statement.
************
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;
******************
************
quit
***********
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