Setting specific options
This step of the wizard allows you to set the database name, database alias, and registration options (using the General and Logs tabs).
The General tab allows you to set common database registration options:
Database name
Type in or use the drop-down list to select the database to be registered.
If several databases have been selected in the Selecting databases step of the wizard, the list of these databases will be displayed in top of the window. Select a database from the list to view/edit its registration information.
Database alias
Enter the alias to be used to display the database in DB Explorer and SQL Manager tools. By default, a database alias generated by the application has the following format: <database_name> on <host_name>[:<port>]
Client charset
If the string data containing national characters are displayed incorrectly in SQL Manager, you should use this drop-down list to manually select the encoding that will be used to store the data on the server.
If you use server version 4.1 or higher, you should choose UTF8 and all data will be displayed correctly. But mind that field data will be displayed correctly only if the encoding of the data stored in this field coincides with the table field encoding. That is, if the Greek encoding is used to store string data in a table like
CREATE TABLE table1 (
str varchar(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
such data will be displayed incorrectly.
Moreover, these data may be sorted incorrectly in other programs, and the result of such string functions as UPPER(), LOWER() will also be incorrect.
If the encoding of data stored in a database coincides with the default encoding of your Windows OS, you can choose Windows charset from the Client charset list.
It is also recommended that the data and field encoding should be brought into compliance. You can use the following commands to do this:
ALTER TABLE table1 MODIFY COLUMN str BINARY(20);
ALTER TABLE table1 MODIFY COLUMN str VARCHAR(20) CHARACTER SET greek;
However, in this case it is necessary to make the corresponding changes in other applications that work with your databases.
Font charset
Specify the character set to be used to display data in the grid.
Refresh objects on connection
This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.
Login prompt before connection
Enables SQL Manager for MySQL to prompt for user name and password each time you connect to the database.
Use compression protocol
Enables using the compressed data protocol when connecting to the database server.
Keep connection alive
Enables pinging server before each query execution.
Use SSL protocol
Enables interchanging data with remote MySQL server via encrypted channel, not allowing intruders to intercept your data.
Note: Enabling this option indicates that SSL protocol should be used, if server supports SSL connections. If it doesn't, then despite the option is enabled, SSL protocol will not be used and no warnings will appear.
Interactive mode
Enables using the interactive_timeout variable value from my.cnf file instead of wait_timeout for connection timeout.
Quote identifiers
Enables quoting all the identifiers with the backquote symbol ('`').
To make SQL scripts obtained using the Extract Database Wizard compatible with older versions of MySQL, uncheck this option.
Note: This option works only with servers that support quoting aliases.
Autoconnect at startup
With this option set, connection to the registered database is established automatically at application startup.
Disable transactions
Enables/disables transactions for this connection.
Create new tab for this database
If this option is checked, the database will be displayed within a separate tab in DB Explorer.
SSL protocol parameters can be defined on the respective tab.
Use SSL protocol
Enables interchanging data with remote MySQL server via encrypted channel, not allowing intruders to intercept your data.
Note: Enabling this option indicates that SSL protocol should be used, if server supports SSL connections. If it doesn't, then despite the option is enabled, SSL protocol will not be used and respective warning will appear.
Only *.pem files are allowed in the fields at this tab.
Use the fields to define path to certificate authority file, to key file and to certificate file. You can use the 
Open button to locate files using standard dialog.
The Logs tab allows you to set log options for the database:
Enable log of metadata changes
Check this option if you wish to log metadata changes of your database in a file.
Write only successfully executed SQL statements to log
If this option is selected, only successfully executed SQL statements will be written to the specified log file.
Log file
This field is enabled if the Enable log of metadata changes option is selected. Type in or use the Save as 
button to specify the path to the *.sql file to store the metadata logs.
Enable log of SQL Editor queries
Check this option if you wish to log your SQL Editor queries in a file.
Log file
This field is enabled if the Enable log of SQL Editor queries option is selected. Type in or use the Save as button to specify the path to the *.sql file to store the logs of SQL queries.
Click the Run button when done to start working with the newly registered database in SQL Manager for MySQL.