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
