[mythtv-users] Using Microsoft Access as a front-end to the, MythTV database: HOWTO
huffcs at yahoo.com
Sat Sep 1 18:19:30 UTC 2007
> ----- 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:
> On Wednesday 25 July 2007 12:10, Craig Huff wrote:
> > $ 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)
> > 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)
> > 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'
> Darren Marshall
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.
Pinpoint customers who are looking for what you sell.
More information about the mythtv-users