Yeah... it's 6 years since the last post to this topic. But...
What I do to access mysql is this. I wrote three programs in freebasic. One inserts, one updates, one does selects on mysql. I then write my runbasic front end that calls one of the three "freebasic servlets" via rc$ = shell$(freebasic.servelet). in the call I pass the name of the db, the table and whatever columns I want to include" if the call is successful, I get back the results in rc$. If the call fails then rc$ = "".
The run basic looks like: a$ = shell$(extrasFilePath$+"password "+name$+" "+pass$)
In this example the freebasic servelet named password, connects to mysql, does a select on the password db, password table for a match for the name$ and pass$. Success returns the environment setup for the user in rc$, a failed match returns rc$="" and an error returns rc$="ERROR". It's works! It's quite fast and Ive done a lot of runbasic front ends for a number of projects.