1. Download mysql-connector-net installation

mysql-connector-net

2. After mysql-connector-net installation is complete, go to the corresponding installation directory and copy the corresponding MySQL .NET dll to CodeSmith’s bin directory and SchemaProviders directory.

The general DLL directory is:

C:\Program Files (x86)\MySQL\MySQL Connector Net 6.9.8\Assemblies\v4.0

3. Restart CodeSmith to take effect

Other solutions:
Solution for codesmith unable to connect to Mysql

Solution for codesmith6.5 connecting to Mysql prompting “Cannot find the requested .Net Framework Data Provider. It may not be installed.”