Table of Contents
The Options
dialog allows you to configure
connection profiles, general program settings, and more. You can
open the Options
dialog window using one of the
following methods:
In the connection dialog window, click the
button.In the main application window select
from the menu.In the sidebar of the dialog, you can select the section you wish to configure. There are three action buttons in the lower right corner of the window:
: Applies and saves changes.
: Discards any changes you have made.
Options
dialog window. If you have not
applied or discarded your changes, you will be prompted to do
so.
The General Options
section allows you to specify
a number of settings that are valid for all graphical MySQL
applications.
Store Window Positions
: When an application
is started the next time, its latest window position will be
reused.
Show Tip of Day
: If checked, a pop-up window
with the tip of the day appears at program startup.
Store Passwords
: If checked, passwords are
stored in the user's connection profile. You can specify the
password storage method:
Plaintext
: Passwords are stored without
encryption; this can be insecure. Obscured
:
Passwords are encrypted using a weak algorithm. This encryption
method is operating system independent. OS
Specific
: Use the default encryption method provided
by your operating system. The default option is
Plaintext
.
Language
: Select the interface language. The
default is English
.
Default Font
: The font used for all
aplication text.
Data Font
: The font used for all query and
table data displayed.
Code Font
: The font used for all queries
entered by the user..
Ignorelist
: Whenever you check the
Do Not Show This Message Again
option on
error and message prompts, they are added to this list. If you
would like a particular message to be shown again, click the
button after selecting the message
from the list.
You may change the font and font size of any of the application fonts by clicking the
button to the right of the font.
The Connections
section allows you to create,
edit, and delete connection profiles. The center box displays a list
of currently available profiles, together with a history of
connections that were made without being stored in a profile. You
can collapse or expand both the Connections
and
History
trees by double clicking them.
Connections are automatically added to the
History
tree whenever you establish a connection
to a MySQL server without using one of the profiles stored under the
Connections
tree. They do not appear in the
drop-down box of the Connection
dialog, but you
can use any of them by manually typing their name into the
Connection
box of the
Connection
dialog.
To edit an existing connection profile, click on its name and change
the values that appear in the Connection
Parameters
and Advanced Parameters
tabs, then click on the button
to save your changes.
When you select a connection profile from either the
Connections
or History
trees,
the Connection Parameters
tab displays the
following fields:
Connection
: The connection profile label.
This is the name by which you refer to the profile and that
appears in the Connection
drop-down box of
the Connection dialog. It may contain any characters, including
spaces. Choose distinctive names so that you can easily tell
which profiles they refer to. The names can help you distinguish
connections to different MySQL servers, or connections as
different MySQL users to a given server.
Username
: The username used to connect to the
MySQL server.
Password
: The password used to connect to the
MySQL server. Note that passwords are not stored in the
connection profile, unless you specify otherwise in the
General
Options section.
Hostname
: The name of the host machine where
the MySQL server runs, or its IP address.
Port
: The TCP/IP port that the MySQL server
listens to on the host machine.
Type
: Specifies the protocol used to connect
to the database server. The default protocol is
MySQL
(which uses the native MySQL protocol).
Schema
: The default database for a connection
when using the MySQL Query Browser.
Notes
: You can use this field to enter
comments or additional information describing the connection
profile.
The Advanced Parameters
tab is not available on
all platforms. Advanced parameters can still be configured in the
Connection dialog. Use the
button to display the Advanced Connection
Options
.
When you select a connection profile from either the
Connections
or History
list,
the Advanced Parameters
tab displays the
following checkboxes:
Use compressed protocol
: If checked, the
communication between the application and the MySQL server will
be compressed, which may increase transfer rates. This
corresponds to starting a MySQL command-line tool with the
--compress
option.
Return number of found rows, not number of affected
rows
: By default, MySQL returns the number of rows
changed by the last UPDATE
, deleted by the
last DELETE
or inserted by the last
INSERT
statement. When this option is
checked, the server returns the number of rows matched by the
WHERE
statement for UPDATE
statements.
Ignore spaces after function names, make them reserved
words
: Normally, any reference to a function name in
an SQL statement must be followed immediately by an opening
parenthesis. If this option is checked, spaces may appear
between the function name and the parenthesis, like this:
COUNT (*)
Enabling this option has the effect that function names become
reserved words. This option corresponds to starting a MySQL
command-line tool with the --ignore-spaces
option.
Allow interactive_timeout seconds of inactivity before
disconnect
: Normally, the connection is closed by the
MySQL server after a certain period of inactivity on the client
side. This period can be set with the
interactive_timeout
variable. If checked, the
server will not close the connection unless the period of
inactivity exceeds the value set by
interactive_timeout
. This corresponds to
starting a MySQL command-line tool with the
--connect-timeout=
option.
seconds
Enable LOAD DATA LOCAL handling
: By default,
the LOCAL
option of the LOAD
DATA
statement is disabled for security reasons.
Enabling this option will allow you to load data from the local
machine (the machine where the client GUI application is
running). This option corresponds to starting a MySQL
command-line tool with the --local-infile=1
option. (Note that this option is ineffective unless the MySQL
server allows LOCAL
handling.)
The Editors
section is used to configure options
specific to the different editors available within the MySQL GUI
Suite. At the time of writing this is limited to the
MySQL Table Editor.
Show SQL command before applying changes
:
Toggles whether the MySQL Table Editor will show you the
CREATE TABLE
or ALTER
TABLE
statement it is about to execute for
confirmation when you click .
All columns Not Null per default
: Determines
whether the MySQL Table Editor will designate columns as being
NOT NULL
by default when creating new
columns.
All integer columns unsigned per default
:
Sets whether integer columns are declared
UNSIGNED
by default when creating new
columns.
Default storage engine
: Sets the storage
engine to be assigned to newly created tables. This value is
independent of the default storage engine of the MySQL server.
PK Naming
: Dictates the format that should be
used to name PRIMARY KEY
columns that are
automatically generated. The
%tablename%
portion will be replaced
with the name of the appropriate table.
Index Naming
: Sets the name automatically
generated for new indexes. The %nr%
string will be replaced with an automatically incrementing
number.
FK Naming
: Configures the name used when
creating new foreign keys.
PK Datatype
: The datatype used when creating
a PRIMARY KEY
column.
Def. data type
The default datatype assigned
to all new columns that are not part of a PRIMARY
KEY
.
The Browser
section allows you to specify options
that relate to the MySQL Query Browser. The Browser
section is divided into three areas: Display
Options
, Query Options
, and
Various
.
The display options affect the appearance of the MySQL Query Browser.
Show advanced toolbars
: Display or hide the
The
Advanced Toolbar.
Hide the tab when only one page is open
:
Determines whether or not to display a tab icon at the top of
the Result
Area if there is only one result area.
Toolbars use gradient background
: Enables
and disables use of gradient effects in the background of the
Query
Toolbar.
Show field overlay images for long VARCHAR, TEXT, and
BLOG fields
: Toggles on and off the BLOB management
icons.
Show composer buttons toolbar
: Toggles on
and off the query composition buttons on the Advanced Toolbar.
Enforce queries to be editable by adding primary key
columns to the select
: Adds PRIMARY
KEY
columns to a query that does not explicitly
SELECT
them to ensure that the results of a
query can be edited. The PRIMARY KEY
columns
will not be displayed in this case, but will still be stored.
Open resultset in associated application after
export
: Causes the associated application to be opened
after choosing the option from
the right click menu of the
Result
Area.