Altium DBlib - MySQL Connection String Examples

Using Altium DBLib > Build Button

Select Driver for ODBC Sources. . . 

Provider=MSDASQL.1;Password=password;Persist Security Info=True;User ID=username;Extended Properties="DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=server.com;OPTION=3;PORT=3306;DATABASE=parts;"

After Building the above Connection String . . . 

The connection string below Auto-magically started working after Building the above connections string.

DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=server.com;OPTION=3;PORT=3306;DATABASE=parts;USER=username;PWD=password;PERSIST SECURITY INFO=True;

Bug:  If you open an existing DBlib that was connected to Access and edit the connection string for a MySQL connection the connection will most likely fail.  

Solution: Enter the MySQL connection string, then Save, Close and Open the DBLib.

That's it!