Difference between revisions of "Database/Drivers/MySQL Native/Connector/C-OOo-Connect-URL"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(→Basic syntax) |
|||
| Line 14: | Line 14: | ||
=== Connection/Authentification === | === Connection/Authentification === | ||
| − | + | {| class="wikitable" | |
| − | + | |- | |
| − | + | ! Property Name | |
| + | ! Definition | ||
| + | ! Comments | ||
| + | |- | ||
| + | | user | ||
| + | | The user to connect as | ||
| + | | | ||
| + | |- | ||
| + | | password | ||
| + | | The password to use when connecting | ||
| + | | | ||
| + | |- | ||
| + | | socket | ||
| + | | The UNIX domain socket to use when connecting | ||
| + | | | ||
| + | |- | ||
| + | | namedpipe | ||
| + | | The Windows named pipe to use when connecting | ||
| + | | | ||
| + | |- | ||
| + | |} | ||
Revision as of 12:29, 2 May 2008
MySQL Connector/OpenOffice.org Connection URL
All: please comment!
This suggestion is based on the MySQL Connector/J documentation.
Basic syntax
sdbc:mysqlc:://[host[:port]]/database[?propertyName1]=[propertyValue1][&propertyName2]=[propertyValue2]...
- 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
Connection/Authentification
| Property Name | Definition | Comments |
|---|---|---|
| user | The user to connect as | |
| password | The password to use when connecting | |
| socket | The UNIX domain socket to use when connecting | |
| namedpipe | The Windows named pipe to use when connecting |
