<div dir="ltr"><br><br><div class="gmail_quote">On Wed, Sep 24, 2008 at 3:34 PM, Bains, Gurvinder <span dir="ltr"><<a href="mailto:gurvinder.bains@christushealth.org">gurvinder.bains@christushealth.org</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;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p style="margin-bottom: 12pt;"><font face="Verdana" size="3"><span style="font-size: 12pt;">Hi,</span></font></p>
<p><font face="Verdana" size="3"><span style="font-size: 12pt;">I get<font color="navy"><span style="color: navy;"> </span></font>the following error while
doing a fresh install and setup of backend and frontend on the same PC:<br>
<br>
QMYSQL3: Unable to connect<br>
QMYSQL3: Can't connect to MySQL server on 'bains-homepc' (111)<br>
<br>
</span></font></p>
<p><font face="Verdana" size="3"><span style="font-size: 12pt;">I
also changed the DBHostName=localhost to the name of the local PC but came
across the same issue.</span></font></p>
<p><font face="Verdana" size="3"><span style="font-size: 12pt;"><br>
I checked permissions on mythconverg database for user 'mythtv' to<br>
ensure I could not login and query the database to rule out access issues.<br>
<br>
During one purge and reinstall cycle I got access denied for mythtv user<br>
so I granted permissions using the command below:<br>
<br>
mysql> grant all on mythconverg.* to mythtv@"<a href="http://192.168.1." title="http://192.168.1." target="_blank">192.168.1.</a>%" identified by
"mythtv";<br>
mysql> flush privileges;<br>
Query OK, 0 rows affected (0.00 sec)</span></font></p></div></div></blockquote></div><br>What happens if you try to run mysql client from the command prompt on the machine in question as the user in question? Do you have access? Can you connect to the DB?<br>
<br>Kevin<br></div>