In your MySQL directory in the "examples" subdirectory is some C examples how to use it. There is also a .dll you can use to connect to MySQL.
ODBC Work the best thou, I tried the rest.
Download the driver http://dev.mysql.com/downloads/connector/odbc/3.51.html
and then use the CVI toolkit. Work really easy.
To build the connection string see my refrence page.
http://www.jattie.co.uk/software/cvi/help/sqlstring.htm
Best regards
Jattie
Jattie van der Linde
Engineering Manager, Software & Automation
TEL Magnetic Solutions Ltd