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

[Craig Huff]

> ----- Original Message ----
> From: Darren <darrenmarshall at linuxfire.biz>
> To: Discussion about mythtv <mythtv-users at mythtv.org>
> Sent: Friday, August 31, 2007 1:51:08 AM
> Subject: Re: [mythtv-users] Using Microsoft Access as a front-end to the, MythTV database: 
> HOWTO
> 
> On Wednesday 25 July 2007 12:10, Craig Huff wrote:
> <snip>
> > $ 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)
> > 
> <snip>
> > 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)
> <snip>
> >
> > Craig.
> >
> 
> 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,
> 
> -- 
> linuxfire.biz
> Darren Marshall

Darren,

Thanks for the advice.  It turned out to be a problem due to having multiple 
"Grant" entries.  I was able to selectively delete the "Grant" records from
the tables and then do a new "Grant" with the scope I wanted.  After that,
everything worked as expected.  It's been over a month now and I have forgotten
the details of what and how I did it, but that's what solved my problem.

Craig.





       
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell. 
http://searchmarketing.yahoo.com/