Difference between revisions of "Database/Drivers/MySQL Native/Connector/C-OOo-Connect-URL"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(→Basic syntax) |
|||
Line 7: | Line 7: | ||
=== Basic syntax === | === Basic syntax === | ||
− | <code> | + | <code>sdbc:mysqlc:://[host[:port]]/database[?propertyName1]=[propertyValue1][&propertyName2]=[propertyValue2]...</code> |
* If the hostname is not specified, it defaults to 127.0.0.1 | * 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 port is not specified, it defaults to 3306, the default port number for MySQL Servers | ||
− | |||
=== Connection/Authentification === | === Connection/Authentification === |
Revision as of 12:17, 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
- user - The user to connect as
- password - The password to use when connecting