mariadb connect

Description

Connect to the mariadb database.

Syntax

mariadb_connect(host_str, user_str, passwd_str, db_str [, ssl_key_file, ssl_cert_file, ssl_ca_file, ssl_ca_path, ssl_cipher])

Parameters

• host_str
  The MariaDB server to connect to. This can be an IP address or hostname.
• user_str
  The MariaDB user.
• passwd_str
  The password for the user.
• db_str
  MariaDB database to use.
• ssl_key_file (optional)
  Private key for SSL connections.
• ssl_cert_file (optional)
  __EDIT_ME__
• ssl_ca_file (optional)
  __EDIT_ME__
• ssl_ca_path (optional)
  __EDIT_ME__
• ssl_cipher (optional)
  __EDIT_ME__

Return Value

• Returns an identifier/handle to the new database connection. false on error.

Example

AddEvent("OnPackageStart", function()
	mariadb_log(SQL_LOGL)

	sql = mariadb_connect(SQL_HOST .. ':' .. SQL_PORT, SQL_USER, SQL_PASS, SQL_DATA)

	if (sql ~= false) then
		print("MariaDB: Connected to " .. SQL_HOST)
		mariadb_set_charset(sql, SQL_CHAR)
	else
		print("MariaDB: Connection failed to " .. SQL_HOST .. ", see mariadb_log file")

		-- Immediately stop the server if we cannot connect
		ServerExit()
	end
end

See also

• mariadb_disconnect
• mariadb_connect
• mariadb_log