Difference between revisions of "Database/Drivers/MySQL Native/Connector/C-OOo-Connect-URL"
(→Connection/Authentification) |
(→Connection/Authentification) |
||
Line 53: | Line 53: | ||
| debug | | debug | ||
| | | | ||
− | | Turn on debug output | + | | Turn on debug output - TBD |
| >= 3.1 | | >= 3.1 | ||
|- | |- |
Revision as of 14:21, 5 May 2008
Contents
MySQL Connector/OpenOffice.org Connection URL
All: please comment!
This suggestion is based on the MySQL Connector/J documentation and the MySQL C-API documentation.
Basic syntax
sdbc:mysqlc:://[host[:port]]/database[?propertyName1]=[propertyValue1][&propertyName2]=[propertyValue2]...
The value of host may be either a hostname or an IP address. If host is NULL or the string "localhost", a connection to the local host is assumed. For Windows, the client connects using a shared-memory connection, if the server has shared-memory connections enabled. Otherwise, TCP/IP is used. For Unix, the client connects using a Unix socket file. For local connections, you can also influence the type of connection to use with the MYSQL_OPT_PROTOCOL or MYSQL_OPT_NAMED_PIPE options to mysql_options(). The type of connection must be supported by the server. For a host value of "." on Windows, the client connects using a named pipe, if the server has named-pipe connections enabled. If named-pipe connections are not enabled, an error occurs.
If the hostname is not specified, it defaults to 127.0.0.1
If the port is not specified, it defaults to 3306, the default port number for MySQL Servers
If the database is not specified, the connection will be made with no default database.
Connection/Authentification
Property Name | Definition | Comments | Supported in GUI |
---|---|---|---|
user | The user to connect as | >= 2.4 | |
password | The password to use when connecting | >= 2.4 | |
socket | The UNIX domain socket or Windows named pipe to use when connecting | If socket is not empty, the string specifies the socket or named pipe that should be used. Note that the host parameter determines the type of the connection. | >= 3.0 |
connection_timeout | See also mysql_options() | >= 3.1 | |
character_set | The name of the character set to use as the default character set. | See also mysql_options() | >= 3.1 |
debug | Turn on debug output - TBD | >= 3.1 | |
compression | Use compression protocol | Values: on/off - See also CLIENT_COMPRESS | >= 3.1 |
Support through the GUI
The OO.org GUI has been frozen for the 3.0 Release. No changes are possible.
The type column shows the meta type and the minimum input length that should be accepted by the GUI. The GUI may use broader input fields to beautify the layout. The GUI does not perform any input checks/validations prior to connecting to the MySQL Server. For example, the GUI will not warn the user when entering a user name with more than 16 characters although the MySQL Server might not support user names of more than 16 characters [[1]]
Property Name | Type | Constraints / Checks | Comment |
---|---|---|---|
user | alphanumeric, >= 16 characters | none | GUI may use a broader input field |
password | alphanumeric, >= 32 characters | none | GUI may use a broader input field |
port | numeric, 5 numbers | none | GUI may use a broader input field |
socket | alphanumeric, >= 32 characters | none | GUI may use a broader input field |
connection_timeout | numeric, 4 numbers | none | GUI may use a broader input field |
debug | alphanumeric, >= 64 characters | none | GUI may use a broader input field |