[mythtv-users] Using Microsoft Access as a front-end to the, MythTV database: HOWTO
Craig Huff
huffcs at yahoo.com
Wed Jul 25 02:40:20 UTC 2007
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/
More information about the mythtv-users
mailing list