Difference between revisions of "Database/Drivers/MySQL Native/Connector/C-OOo-Connect-URL"

From Apache OpenOffice Wiki
Jump to: navigation, search
(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
Personal tools