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

[Mark Weil]

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.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100222/b5d4ca01/attachment.htm>