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

[Douglas Phillipson]

It means that "mythtv" is the password for the database "mythconverg".

Doug P

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
>>