[mythtv-users] Re:Anyone get Microsoft(bad word I know) Accessworking on the mysql database?

[mythtv]

Well,

I did this
grant all on mythconverg.* to "%"@"192.168.0.%" identified by "mythtv";

What does this mean? what is identified by mythtv?

what username password do I put into Access? root or mythtv?

What is the ODBC source for myth database?

thanks


David Vasquez wrote:

> Sounds like you haven't granted access for your
> Windows box to access the MySQL database.  See the
> section 'Modifying access to the MySQL database for
> multiple systems' in the 'How To' documentation to
> grant permissions at whatever level you want/need.
>
> In W2K, I was then be able to test the ODBC connection
> from my Windows box.  I have no idea if you can test
> the connection w/ other versions.  If you still have
> problems, check your firewall.
>
> Assuming that's a success, go into Access and set up a
> connection to the external database.  In Access 2000,
> I created a new, blank database, then did File->Get
> External Data->Link Tables.
>
> This brought up a dialog box where I set Type of File
> to ODBC and the selected the ODBC source for the Myth
> database.
>
> David
>
> --- mythtv <mythtv at bruce.homelinux.com> wrote:
> > If you dont mind a few more details. I set up the
> > ODBC, but I keep getting an
> > authorization error when trying to access the
> > mythconverg database. I am using
> > user name root, but no password. How do I set up
> > mythconverg?
> >
> >
> > Bruce
> >
> >
> > David Vasquez wrote:
> >
> > > I got it to work.
> > >
> > > You need to set up the MySQL database to accept
> > > connections from your Windows machine and then
> > install
> > > the MySQL ODBC driver.
> > >
> > > Once you have that set up, simply treat it as any
> > > other external ODBC source.
> > >
> > > If you need more details on any of the steps, just
> > let
> > > me know.  Depending on what you want to do, you
> > may
> > > also consider using the MySQL Control Center.
> > >
> > > David
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Protect your identity with Yahoo! Mail
> > AddressGuard
> > > http://antispam.yahoo.com/whatsnewfree
> > >
> > >
> >
> ------------------------------------------------------------------------
> > > _______________________________________________
> > > mythtv-users mailing list
> > > mythtv-users at mythtv.org
> > >
> >
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> >
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/