Options property
Previous  Top  Next

See Also Properties Methods Events Example
Unit
MySQLServer

Applies to
TMySQLServer component

Declaration
property Options: TMySQLServerOptions default [coInteractive];

Description
These allow you to change the connection options when you connect to the mysql server. Follow is an extract from the MySQL Manual:

Delphi/Kylix
MySQL
Description
coLongPassword
CLIENT_LONG_PASSWORD
New more secure passwords
coFoundRows
CLIENT_FOUND_ROWS
Return the number of found (matched) rows, not the number of affected rows.
coLongFlag
CLIENT_LONG_FLAG
Get all column flags
coConnectWithDB
CLIENT_CONNECT_WITH_DB
One can specify db on connect
coNoSchema
CLIENT_NO_SCHEMA
Don't allow database.table.column
coCompress (see Compression property)
CLIENT_COMPRESS
Use compression protocol.
coODBC
CLIENT_ODBC
The client is an ODBC client. This changes mysqld to be more ODBC-friendly.
coLocalFiles
CLIENT_LOCAL_FILES
Enable LOAD DATA LOCAL handling.
coIgnoreSpace
CLIENT_IGNORE_SPACE
Allow spaces after function names. Makes all functions names reserved words.
coInteractive
CLIENT_INTERACTIVE
Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable will be set to the value of the session interactive_timeout variable.



coSSL
CLIENT_SSL
If you have compiled the MyComponents using the HAVE_SSL directive (see the product.inc file in the source directory) then you will have this option available. You must now also have the OpenSSL libeay32.dll and ssleay32.dll libraries available to your application and system and may specify the key, ca, etc paths using the Params property of the TMySQLServer.
coIgnoreSigpipe
CLIENT_IGNORE_SIGPIPE
IGNORE sigpipes
coTransactions
CLIENT_TRANSACTIONS
Client knows about transactions
coProtocol41
CLIENT_PROTOCOL_41
New 4.1 protocol
coSecureConnection
CLIENT_SECURE_CONNECTION
New 4.1 authentication
coMultiQueries
CLIENT_MULTI_QUERIES
Tell the server that the client may send multi-row-queries (separated with ';'). If this flag is not set, multi-rowqueries are disabled. New in 4.1.
soAutoCreate

This option differs in that it has nothing to do with the initial connection. If set to True this will recreate you database and all attached table structures (which also doAutoCreate set) on the MySQL server when the TMySQLServer connects, see CreateDatabase for more info. NOTE: You may wish to disable this option after the database has been recreated successfully, otherwise this create script will be executed everytime the TMySQLServer connects. Because it uses "IF NOT EXISTS" SQL this won't cause any harm, but it is additional work to be done by both your application and the mysql server.
soDropIfExists

If doAutoCreate is enabled and this setting is enabled the compiled sql will be prefixed with a "drop database if exists.." statement. This setting is also used with the CreateDatabase method. WARNING: Be very, very careful with this option, if it is enabled on an existing database and the TMySQLServer is activated, even just at designtime you will lose all tables and data in this database.
soCloseOnChildren

If enabled, this will automatically disconnect the TMySQLServer if and when all children have closed.