New/Edit Project - MySQL

This page covers the MySQL-specific connection editor used when creating or editing a project. The overall workflow still follows the shared project editor, but the MySQL form adds SSL and HTTP tunnel settings that do not appear on the SQL Server page.

Connection details

• Server, user name, password, and port: enter the MySQL server endpoint and account details. When no saved port is available, the current form falls back to the standard MySQL port 3306.
• Database: once the server and user name are present, load or choose the target database for the project. The database selector stays disabled until the required connection details are available.
• Save Password: this option is only enabled when a password has been entered.
• Use External DLL: enable this when you need SQL Delta 7 to use an external MySQL client DLL for the connection.

SSL and HTTP tunnel options

• The MySQL editor has separate Details, SSL, and HTTP Tunnel tabs.
• Use SSL Connection enables the CA file, certificate file, key file, and cipher list fields used for certificate-based connections.
• Use HTTP Tunnel Connection enables the tunnel URL plus optional proxy host, proxy port, proxy user name, and proxy password fields.
• The current form treats SSL and HTTP tunnel as alternatives. Enabling one turns off the other set of options.

Common MySQL project tasks

• Use the SSL Assist action, or the MySQL SSL/TLS Connection page, when the required SSL files or OpenSSL DLLs need attention.
• Create a new database from the editor when your account has permission. The create-database action is not available for Data Compare projects.
• Reuse the saved server list for frequent connections. Successful connection and database-loading operations update the stored server entry.

Connection flow

In the current MySQL editor, the usual sequence is to enter the server, user name, optional password, and port, then test the connection or load the database list. After selecting the required database, continue through the remaining project tabs and either save the project or run it.

Terminology notes

For MySQL projects, the database name is usually the main container selected first. Shared pages that talk about schema map less directly here than they do for SQL Server, so focus on the selected database and object names when following shared project instructions.

For the shared editor workflow, see New/Edit Project Overview.