I just started out with FileMaker Pro 13 last week, and of course I wanted to drive it to the stops to see if I could break it. I thought I’d see if FM could handle a MySQL database ODBC connection to one of my Dreamhost hosted MySQL databases. I have some connections to MySQL 5.3 ANSI Driver set up in Windows 7 ODBC Data Source Administrator. In FM, I tried "Convert an Existing File>slide Files of type down to ODBC Source and all my Data Sources show up. I clicked on one of the MySQL connections, but FM wants a user name, password for the ODBC data source. What does FM want here? It’s not the username, password on the MySQL database. Tried that, besides it’s part of the settings behind the ODBC data sources already. This data source still works for MS Access in Windows and Access doesn’t ask for authentification. Blank doesn’t work. It’s not my Windows admin account login. I’m out of guesses. Where is this username and password set? What does FM want here?
Way down in the FM documentation, they say the odbc connection is for MySQL 5.5 databases, and DH MySQL is 5.1 according to the wiki. Is that the problem? The database version, seems to me, would be isolated from FM by the ODBC driver.
Is it possible for me to set up MySQL 5.5 for a test? Or maybe a local Windows or Ubuntu machine? Are there any MySQL 5.5 test databases out there?