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

[mythtv]

Nevermind.

I had to use a password. mythtv. Now I can see the Db's.

Thanks for the help..

mythtv wrote:

> 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/
>
>   ------------------------------------------------------------------------
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users