PyInstaller Build Error: ImportError: No Module Named

When using PyInstaller to build a Python script into an executable, it's possible to encounter the error "ImportError: No module named 'blah'". This issue commonly occurs when there are dynamic imports or dependencies not recognized by the spec file generated during the build process.

To address this error, there are two main approaches:

1. Add Unused Imports: Manually add imports of the missing modules to your code. By including unused imports, PyInstaller will recognize these dependencies and include them in the executable.
2. Specify Dependencies: Instead of adding unused imports, you can explicitly tell PyInstaller to include certain modules. This can be done by modifying the spec file generated by Makespec.py. In the binpath field of the spec file, add a path to the missing module's location.

In your case, the error mentions "No module named mysql". To resolve this, you can either add an unused import of mysql or add the following line to the binpath field in the spec file:

binpath = ['/path/to/mysql/module']

It's important to note that the onefile option in PyInstaller merely combines all generated files into a single executable. It does not affect the dependencies that need to be included in the build.