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

[Billy Macdonald]

>
> I'm not the mysql wiz but these two things I notice.  The quotes are
> different in the error and your grant commands.
>
> try grant .... 'mythtv'@'192.168.1.%' ..;
>
> if that's not it, try granting usage for the user.
>
> GRANT USAGE ON *.* TO 'mythtv'@'192.168.1.%';
>
> Good luck.
>
> Billy
>

Oh, I just remembered that mysql changed password functions and the
new function doesn't work with the odbc driver.  try:

set password for 'mythtv'@'192.168.1.%' = old_password('mythtv');

Good luck again,
Billy