1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>libzdb | MySQL Options</title>
<link rel="stylesheet" href="libzdb.css">
</head>
<body>
<h1>
MySQL URL properties
</h1>
<table>
<tr>
<th>Property</th>
<th>Description</th>
<th>Type</th>
</tr>
<tr>
<td >
user
</td>
<td>
The MySQL login ID. This property is required unless the auth-part of the URL was used.
<p class="example">Example: user=root</p>
</td>
<td>
String
</td>
</tr>
<tr>
<td >
password
</td>
<td>
The password for user. This property is required unless the auth-part of the URL was used.
<p class="example">Example: password=swordfish</p>
</td>
<td>
String
</td>
</tr>
<tr>
<td >
connect-timeout
</td>
<td>
Connect timeout in seconds. Default is 3 seconds. It is a checked runtime error to use a value equal to or less than 0.
<p class="example">Example: connect-timeout=5</p>
</td>
<td>
Integer (seconds)
</td>
</tr>
<tr>
<td>
compress
</td>
<td>
Use the compressed client/server protocol. Default is false.
<p class="example">Example: compress=true</p>
</td>
<td>
Boolean (true/false)
</td>
</tr>
<tr>
<td>
use-ssl
</td>
<td>
Used for establishing secure connections using SSL. OpenSSL support
must be enabled/linked in the client library. Default is false.
<p class="example">Example: use-ssl=true</p>
</td>
<td>
Boolean (true/false)
</td>
</tr>
<tr>
<td>
charset
</td>
<td>
Use this character set when communicating with the server. MySQL charsets, e.g. "utf8" or "latin1".
<p class="example">Example: charset=utf8</p>
</td>
<td>
String
</td>
</tr>
<tr>
<td>
secure-auth
</td>
<td>
Whether to connect to a server that does not support the password hashing used in MySQL 4.1.1 and later. Default is false.
<p class="example">Example: secure-auth=true</p>
</td>
<td>
Boolean (true/false)
</td>
</tr>
<tr>
<td>
unix-socket
</td>
<td>
Connect to the database server over a unix socket on localhost. The unix-socket value should be the full path to the socket file.
MySQL use default the file /tmp/mysql.sock. Note that this is different from the PostgreSQL unix-socket parameter which specify
the path to the <em>directory</em> where the socket file is located.
<p class="example">Example: unix-socket=/tmp/mysql.sock</p>
</td>
<td>
String (file path)
</td>
</tr>
</table>
</body>
</html>
|
