Use Environment Options to tune the general program options, including options of the query builder, result grids and so on. To call this dialog select the Options | Environment Options menu item.
Save desktop on disconnect
Saves all the database windows and their positions on disconnecting from the database.
Play sounds
Turns the MySQL Query sound effects on.
Disable multiple instances
Prohibits running multiple instances of MySQL Query.
Encrypted passwords
Encrypts passwords for connecting to databases in the Windows registry.
Show hosts in DB Explorer
Shows/hides database hosts in the DB Explorer tree.
History
Check option Use History to keep the history of edited queries and set the number of queries to keep in the History Depth box.
Show history for the current query only
Check this option to display the whole query history, or uncheck it to display the history only for the current query.
Confirm exit from MySQL Query
If this option is on, the program requires confirmation when you want to exit MySQL Query.
Confirm successful compilation
If this option is on, the program requires confirmation for the successful compilation.
Show hosts in DB Explorer
Shows/hides database hosts in the DB Explorer tree.
Show history in DB Explorer
Shows/hides query history in the DB Explorer tree.
Select condition row
Displays the selected condition in different row on the Criteria and Grouping Criteria tabs of the Query Builder.
Drag field name
Displays the dragged field name in the Builder area.
Hide selection when inactive
Hides the selection when Query Builder is inactive.
Show field types in hints
Displays the field type next to the field in the table box.
Visible Tabs
These options specify which Query Builder tabs are available and which are not. Check boxes to make the appropriate tabs visible.
Script Format
These options specify the case formatting of keywords and functions in query text on the Edit tab. As is saves the original case, Uppercase sets all the keywords/functions to upper case, Lowercase sets all the keywords/functions to lower case, and First upper sets the first letters of all keywords/functions to upper case.
Style
These options specify how different the Query Builder objects look like - 3D, flat, etc.
Color Palette
These options define colors of different Query Builder objects: condition row, active caption, table client area, etc. Click an item to select a color for the appropriate Query Builder object.
System Font Name
Defines the font name used by MySQL Query.
System Font Size
Defines the font size used by MySQL Query.
The box below displays the sample text using the selected font.
Grid
Defines the background color of the data grid.
Row
Defines the color of the selected row in the data grid.
Stripy
Defines the color of the odd rows if the Stripy Grids option is on.
Text
Defines the text that stands for the NULL value.
Font Color
Defines the font color displaying NULL values in the grid.
Integer Fields
Defines the format for displaying TINYINT, SMALLINT, MEDIUMINT, INTEGER, and BIGINT fields.
Float Fields
Defines the format for displaying FLOAT, DOUBLE and DECIMAL fields.
DateTime Fields
Defines the format for displaying DATETIME fields.
Date Fields
Defines the format for displaying DATE fields.
Time Fields
Defines the format for displaying TIME fields.
String Fields Width
Defines the width of CHAR and VARCHAR fields displayed in the grid.
Select all records
Selects all the records from the table, no matter how many records there are in table.
Records
This option is available only if Select all records is off. It defines the maximum number of records, selected from the table at a time.
Stripy Grids
Displays the odd grid rows in a different color, defined by the Stripy option.
Autofit Columns
This option is available only if Save Grid View is off. It shrinks the grid columns so that the longest visible column value fits.
Save Grid View
This option is available only if Autofit Columns is off. It saves the original grid width.
Use Ctrl+Up to increase spin values
Allows you to use Ctrl+Up and Ctrl+Down key combinations for editing the spin values (integer field values).
Show editor immediately
Allows editing the cell value right after the cell is clicked.
The Localization tab is provided for managing the MySQL Query localization files.
You can create your own *.lng files similar to those, available in the $(MySQL Query)\Languages folder, add them to the list of available languages on this tab and set the new language as a program interface language.
Default Directory
The default directory for adding the new *.lng files.
Choose Program Language
Selects the program interface language.
Available Languages
Lists all the languages available for localization and the corresponding *.lng files. Double-click a language in the list to edit its name or *.lng file.
Add Defaults
Searches in the Default Directory folder for the *.lng files and adds all them to the list.
Add
Opens a dialog for setting the name and the corresponding file of a new language file.
Edit
Opens a dialog for changing the name or the corresponding *.lng file of the language selected in the Available Languages list box.
Delete
Removes the language selected in the Available Languages list box.
Default Paper Size
This panel allows you to select the default paper size from the four available choises.
Default Page Orientation
Selects the default page orientation - Portrait or Landscape.
Autofit Row Height
Check this option to fit the row heights to the paper size.
