for mysql connectivity testing you can specify where to connect:<br>(From a command prompt)<br><br>*************<br>mysql -u <username> -p -h localhost<br>**********<br>-u = username<br>-p = password (it'll prompt you after you press 'Enter')<br>
-h = host<br><br>you can also specify a database by just tacking it onto the end of the statement.<br><br>************<br>mysql -u mythtv -p -h localhost mythconverg<br>**********<br><br>and if it's local, you don't need the -h switch;<br>
<br>************<br>mysql -u mythtv -p mythconverg<br>***********<br><br>or the database name on the server;<br><br>***************<br>mysql -u mythtv -p<br>**************<br><br>Once at the mysql prompt you can type <br>
<br>*****************<br>show databases;<br><br>*******************<br>to display them.<br>you can<br><br>*******************<br>use mythconverg;<br><br>show tables;<br>******************<br><br>************<br>quit<br>***********<br>
to exit.<br><br><div class="gmail_quote">On Mon, Feb 22, 2010 at 1:24 PM, Travis Tabbal <span dir="ltr"><<a href="mailto:travis@tabbal.net">travis@tabbal.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Mon, Feb 22, 2010 at 1:59 PM, mark stewart <span dir="ltr"><<a href="mailto:ethereal9@gmail.com" target="_blank">ethereal9@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello there.<br><br>I downloaded a binary and installed it along with mysql on my windows 7 machine.<br><br>I configured mysql according to this web page <a href="http://www.mythtv.org/wiki/MythTV_on_Windows" target="_blank">http://www.mythtv.org/wiki/MythTV_on_Windows</a><br>
<br>When I ran the myth backend I used these settings<br><br>Database host name : localhost<br>Should I test connectivity : yes<br>Database port : 6543<br>Database name mythconverg<br>Database user name : mythtv<br>Database password : mythtv<br>
Unique identifier : Quad-Core<br>Wake-On-Lan no<br><br>The error I get is<br><br>Cannot connect to port 6543 on database host localhost<br><br>The port is open in my router.<br><br>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.<br>
<br>Any help would be greatly appreciated</blockquote><div><br></div><div><br></div></div></div><div>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? </div>
<div><br></div><div>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. </div>
</div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br>