MySQL Connection Strings

Create User and Password

Use the MySQL Workbench to create users and set privileges (permissions).

Select Server > User and Privileges

click on image to view

Important %

Set the 'Limit to Host Matching' for the User Privileges to %

click on image to view

Example MySQL Connection Strings for Parts Frontend

ODBC Driver Link: MySQL :: Download Connector/ODBC

Local Named Server (localhost)

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

Remote or Local Server with Static IP Address

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

Amazon Web Services

us-west - example connection string

DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=partsdb.xxxxxxxxx.us-west-1.rds.amazonaws.com;OPTION=3;PORT=3306;DATABASE=parts;USER=tgsky_altium_rds;PWD=ZaWw2z3q;PERSIST SECURITY INFO=True;

Required Folder Structure for DBLib:

Store the Altium *.DBLib in the same folder as the Footprints and Symbols folders.

click on image to view

Altium DBLib - Example MySQL Connection Strings

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

Example connection string using an IP Address

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

Important  Accent Character `

For MySQL in the Altium DBlib select the Advanced button and enter accent characters for the Left and Right Quote Characters. 

The accent character is the ` key above the Tab key on your keyboard.

Related Links:

ConnectionStrings.com 
Connector/ODBC Option Parameters

Remote MySQL connections - A2 Hosting

That's it !