summaryrefslogtreecommitdiffstats
path: root/libmariadb/man/mysql_real_connect.3
diff options
context:
space:
mode:
Diffstat (limited to 'libmariadb/man/mysql_real_connect.3')
-rw-r--r--libmariadb/man/mysql_real_connect.3171
1 files changed, 171 insertions, 0 deletions
diff --git a/libmariadb/man/mysql_real_connect.3 b/libmariadb/man/mysql_real_connect.3
new file mode 100644
index 00000000..3a7a7f60
--- /dev/null
+++ b/libmariadb/man/mysql_real_connect.3
@@ -0,0 +1,171 @@
+.\"t
+.\" Automatically generated by Pandoc 2.5
+.\"
+.TH "mysql_real_connect" "3" "" "Version 3.3.1" "MariaDB Connector/C"
+.hy
+.SS Name
+.PP
+mysql_real_connect \- establishes a connection to a MariaDB database
+server
+.SS Synopsis
+.IP
+.nf
+\f[C]
+MYSQL * mysql_real_connect(MYSQL *mysql,
+ const char *host,
+ const char *user,
+ const char *passwd,
+ const char *db,
+ unsigned int port,
+ const char *unix_socket,
+ unsigned long flags);
+\f[R]
+.fi
+.SS Description
+.PP
+Establishes a connection to a database server.
+.SS Parameter
+.IP \[bu] 2
+\f[C]mysql\f[R] \- a mysql handle, which was previously allocated by
+\f[B]mysql_init(3)\f[R]
+.IP \[bu] 2
+\f[C]host\f[R] \- can be either a host name or an IP address.
+Passing the NULL value or the string \[lq]localhost\[rq] to this
+parameter, the local host is assumed.
+When possible, pipes will be used instead of the TCP/IP protocol.
+Since version 3.3.0 it is also possible to provide a comma separated
+list of hosts for simple fail over in case of one or more hosts are not
+available.
+.IP \[bu] 2
+\f[C]user\f[R] \- the user name.
+.IP \[bu] 2
+\f[C]passwd\f[R] \- If provided or NULL, the server will attempt to
+authenticate the user against those user records which have no password
+only.
+This allows one username to be used with different permissions
+(depending on if a password as provided or not).
+.IP \[bu] 2
+\f[C]db\f[R] \- if provided will specify the default database to be used
+when performing queries.
+.IP \[bu] 2
+\f[C]port\f[R] \- specifies the port number to attempt to connect to the
+server.
+.IP \[bu] 2
+\f[C]unix_socket\f[R] \- specifies the socket or named pipe that should
+be used.
+.IP \[bu] 2
+\f[C]flags\f[R] \- the flags allows various connection options to be set
+.PD 0
+.P
+.PD
+.PP
+.TS
+tab(@);
+lw(35.0n) lw(35.0n).
+T{
+Flag
+T}@T{
+Description
+T}
+_
+T{
+\f[C]CLIENT_FOUND_ROWS\f[R]
+T}@T{
+Return the number of matched rows instead of number of changed rows.
+T}
+T{
+\f[C]CLIENT_NO_SCHEMA\f[R]
+T}@T{
+Forbids the use of database.tablename.column syntax and forces the SQL
+parser to generate an error.
+T}
+T{
+\f[C]CLIENT_COMPRESS\f[R]
+T}@T{
+Use compression protocol
+T}
+T{
+\f[C]CLIENT_IGNORE_SPACE\f[R]
+T}@T{
+Allows spaces after function names.
+All function names will become reserved words.
+T}
+T{
+\f[C]CLIENT_LOCAL_FILES\f[R]
+T}@T{
+Allows LOAD DATA LOCAL statements
+T}
+T{
+\f[C]CLIENT_MULTI_STATEMENTS\f[R]
+T}@T{
+Allows the client to send multiple statements in one command.
+Statements will be divided by a semicolon.
+T}
+T{
+\f[C]CLIENT_MULTI_RESULTS\f[R]
+T}@T{
+Indicates that the client is able to handle multiple result sets from
+stored procedures or multi statements.
+This option will be automatically set if CLIENT_MULTI_STATEMENTS is set.
+T}
+T{
+\f[C]CLIENT_REMEMBER_OPTIONS\f[R]
+T}@T{
+Rembers options passed to \f[B]mysql_optionsv(3)\f[R] if a connect
+attempt failed.
+If MYSQL_OPTIONS_RECONNECT option was set to true, options will be saved
+and used for reconnection.
+T}
+.TE
+.SS Return value
+.PP
+returns a connection handle (same as passed for 1st parameter) or NULL
+on error.
+On error, please check \f[B]mysql_errno(3)\f[R] and
+\f[B]mysql_error(3)\f[R] functions for more information.
+.SS Notes
+.IP \[bu] 2
+The password doesn\[cq]t need to be encrypted before executing
+mysql_real_connect().
+This will be handled in the client server protocol.
+.IP \[bu] 2
+The connection handle can\[cq]t be reused for establishing a new
+connection.
+It must be closed and reinitialized before.
+.IP \[bu] 2
+mysql_real_connect() must complete successfully before you can execute
+any other API functions beside \f[B]mysql_optionsv(3)\f[R].
+.IP \[bu] 2
+host parameter may contain multiple host/port combinations (supported
+since version 3.3.0).
+The following syntax is required:
+.RS 2
+.IP \[bu] 2
+hostname and port must be seperated by a colon (:)
+.IP \[bu] 2
+IPv6 addresses must be enclosed within square brackets
+.IP \[bu] 2
+hostname:port pairs must be be seperated by a comma (,)
+.IP \[bu] 2
+if only one host:port was specified, the host string needs to end with a
+comma.
+.IP \[bu] 2
+if no port was specified, the default port will be used.
+.PP
+\f[B]Examples for failover host string:\f[R]
+.PP
+\f[C]host=[::1]:3306,192.168.0.1:3306,test.example.com\f[R]
+.PP
+\f[C]host=127.0.0.1:3306,\f[R]
+.RE
+.SS See also
+.IP \[bu] 2
+\f[B]mysql_init(3)\f[R]
+.IP \[bu] 2
+\f[B]mysql_close(3)\f[R]
+.IP \[bu] 2
+\f[B]mariadb_reconnect(3)\f[R]
+.IP \[bu] 2
+\f[B]mysql_error(3)\f[R]
+.IP \[bu] 2
+\f[B]mysql_errno(3)\f[R]