[mythtv-users] QMYSQL3: Can't connect to MySQL server during backend setup.

Kevin Kuphal kkuphal at gmail.com
Wed Sep 24 21:49:44 UTC 2008


On Wed, Sep 24, 2008 at 3:34 PM, Bains, Gurvinder <
gurvinder.bains at christushealth.org> wrote:

>  Hi,
>
> I get the following error while doing a fresh install and setup of backend
> and frontend on the same PC:
>
> QMYSQL3: Unable to connect
> QMYSQL3: Can't connect to MySQL server on 'bains-homepc' (111)
>
>  I also changed the DBHostName=localhost to the name of the local PC but
> came across the same issue.
>
>
> I checked permissions on mythconverg database for user 'mythtv' to
> ensure I could not login and query the database to rule out access issues.
>
> During one purge and reinstall cycle I got access denied for mythtv user
> so I granted permissions using the command below:
>
> mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by
> "mythtv";
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>

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?

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080924/0ecdf0f6/attachment.htm 


More information about the mythtv-users mailing list