Difference between revisions of "Database/Drivers/MySQL Native/Connector/C-OOo-Connect-URL"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(New page: == MySQL Connector/OpenOffice.org Connection URL == '''All: please comment!''' This suggestion is based on the MySQL Connector/J documentation.) |
|||
Line 4: | Line 4: | ||
This suggestion is based on the MySQL Connector/J documentation. | This suggestion is based on the MySQL Connector/J documentation. | ||
+ | |||
+ | === Basic syntax === | ||
+ | |||
+ | <code>mysql://[host[:port]]/database[?propertyName1]=[propertyValue1][&propertyName2]=[propertyValue2]...</code> | ||
+ | |||
+ | * 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 |
Revision as of 12:09, 2 May 2008
MySQL Connector/OpenOffice.org Connection URL
All: please comment!
This suggestion is based on the MySQL Connector/J documentation.
Basic syntax
mysql://[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