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

[Trey Thompson]

On 8/31/07, Darren <darrenmarshall at linuxfire.biz> wrote:
> On Wednesday 25 July 2007 12:10, Craig Huff wrote:
> Have you set a root password for mysql?
> When mysql is first installed  root has a null password. You must set a
> password for root to gain access to the database.
>
> mysqladmin -u root password 'new-password'
>
> > 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.
> >
> >
> >
> >
> >
> > ___________________________________________________________________________
> >_________ Park yourself in front of a world of choices in alternative
> > vehicles. Visit the Yahoo! Auto Green Center.
> > http://autos.yahoo.com/green_center/
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> --
> linuxfire.biz
> Darren Marshall
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

There are a TON of posts about this on the list archives if you search
for "mysql reset root" or something like that.

http://www.gossamer-threads.com/lists/mythtv/users/