[mythtv-users] Using Microsoft Access as a front-end to the, MythTV database: HOWTO

[Nick Rout]

I may be betraying the huge gaps in my MySQL knowledge, but I believe that
the privileges tables are in the database named mysql - this is a separate
database to the mythconverg database. It has all mysql's own settings in
it.



On Wed, July 25, 2007 2:40 pm, Craig Huff wrote:
> David,
>
> I was intrigued and tried to follow the directions, but I don't know
> enough SQL to solve the problem I ran into.
>
> I don't know if you do either, but perhaps someone on the list can tell me
> (us) how to get out of the corner I'm in.
>
> I have tried to set up security on the database per the MythTV HOWTO in
> order to restrict access to my subnet with:
>
> $ mysql -u root -pmythtv mythconverg
> mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by
> "mythtv";
> mysql> flush privileges;
> mysql> quit
>
> After the grant command, and again after the flush command, I get:
>     Query OK, 0 rows affected (0.00 sec)
>
> Now when I tried to follow the Access HOWTO, everything works fine until I
> get to the Select Data Source dialog's Machine Data Source tab, select the
> mythtv Data Source Name and click the OK button at the bottom.  When I do
> that, I get a Microsoft Access pop-up reporting "ODBC--call failed" and
> containing "OK" and "Help" buttons.  Ignoring the "Help" button, when I
> click the "OK" button, I get a new pop-up window which reports:
>
>     [MySQL][ODBC 3.51 Driver][mysqld-5.0.27]Access denied for user
> 'mythtv'@'192.168.1.%' to database 'mysql' (#1044)
>
> I tried changing the security per the MythTV HOWTO to be wide open, the
> pertinent grant command being:
>
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
>
> but got no different response from mysql nor from the Windows operations.
>
> FWIW, I'm using Access 97 on XP Pro w/ SP2.
>
> Now what???  Why does the error talk about database 'mysql' rather than
> 'mythconverg'?  Why can't I connect?  How do I fix it?
>
> Of equal concern is: Will I have a similar problem when I get the time to
> finish my new (first one, too) MythTV frontend machine and have it not
> able to access the database on the backend?
>
> Any advice?  Anyone?
>
> Craig.
>
>

-- 
Nick Rout