On 6/15/05, scott <[EMAIL PROTECTED]> wrote: > Fred A. Miller wrote: > > >On Monday 13 June 2005 2:46 pm, Doug Hernandez wrote: > > > > > >>I got Base working from a MySQL server, but not its native database. > >>Working from the MySQL server makes db/table creation fast and easy, > >>but my install (Fedora 4-test-3) fails horribly and dies whenever I > >>try to create a form or report. > >> > >>I'm going to upgrade to FC4 tonight, then use Base to cook up a DB. > >>I'll let you know how it goes. > >> > >> > > > >Try SUSE Linux 9.3.....all good reports so far. > > > >Fred > > > > > > > How do you connect base to MySQL? > > Scott > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
Scott, I'm writing this from memory, but it should get you through the process. First, add a user to your mysql db with a grant statement. Be sure to include in the host 127.0.0.1 (I found problems with just using 'localhost'). mysql -> grant all on somedb.* to 'someuser'@'127.0.0.1' identified by 'password'; Install the myodbc drivers (you can get them from the mysql web site) and be sure you add the datasource to the conf files (whose names escape me at the moment, see the myodbc documentation). Run base, choosing to connect to existing db. Tell the wizard you want to use a mysql db with myodbc drivers. Tada! -- Douglas Hernandez (612) 331-2547 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
