WEBINAR
MariaDB 101: Learning the Basics of MariaDB
Learn the various parameters and options for connecting to a MariaDB server using the command-line client and other tools.
This article covers connecting to MariaDB and the basic connection parameters. If you are completely new to MariaDB, take a look at A MariaDB Primer first.
In order to connect to the MariaDB server, the client software must provide the correct connection parameters. The client software will most often be the mariadb client, used for entering statements from the command line, but the same concepts apply to any client, such as a graphical client, a client to run backups such as mariadb-dump, etc. The rest of this article assumes that the mariadb command line client is used.
If a connection parameter is not provided, it will revert to a default value.
For example, to connect to MariaDB using only default values with the mariadb client, enter the following from the command line:
In this case, the following defaults apply:
The host name is localhost.
The user name is either your Unix login name, or ODBC on Windows.
No password is sent.
The client will connect to the server with the default socket, but not any particular database on the server.
These defaults can be overridden by specifying a particular parameter to use. For example:
In this case:
-h specifies a host. Instead of using localhost, the IP 166.78.144.191 is used.
-u specifies a user name, in this case username
-p
Connect to the MariaDB server on the given host. The default host is localhost. By default, MariaDB does not permit remote logins - see .
The password of the MariaDB account. It is generally not secure to enter the password on the command line, as other users on the system can see it as part of the command that has been run. If you include the -p or --password option, but leave out the password, you are prompted for it, which is more secure.
On Windows systems that have been started with the --enable-named-pipe option, use this option to connect to the server using a named pipe.
The TCP/IP port number to use for the connection. The default is 3306.
Specifies the protocol to be used for the connection for the connection. It can be one of TCP, SOCKET, PIPE or MEMORY (case-insensitive). Usually you would not want to change this from the default. For example on Unix, a Unix socket file (SOCKET) is the default protocol, and usually results in the quickest connection.
TCP: A TCP/IP connection to a server (either local or remote). Available on all operating systems.
SOCKET: A Unix socket file connection, available to the local server on Unix systems only. If socket is not specified with --socket, in a config file or with the environment variable MYSQL_UNIX_PORT then the default /tmp/mysql.sock are used.
PIPE
Only available on Windows systems in which the server has been started with the --shared-memory option, this specifies the shared-memory name to use for connecting to a local server. The value is case-sensitive, and defaults to MARIADB.
For connections to localhost, this specifies either the Unix socket file to use (default /tmp/mysql.sock), or, on Windows where the server has been started with the --enable-named-pipe option, the name (case-insensitive) of the named pipe to use (default MARIADB).
A brief listing is provided below. See and for more detail.
Enable TLS for connection (automatically enabled with other TLS flags). Disable with '--skip-ssl'
CA file in PEM format (check OpenSSL docs, implies --ssl).
X509 cert in PEM format (implies --ssl).
TLS cipher to use (implies --ssl).
X509 key in PEM format (implies --ssl).
Certificate revocation list (implies --ssl).
Certificate revocation list path (implies --ssl).
Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default.
The MariaDB user name to use when connecting to the server. The default is either your Unix login name, or ODBC on Windows. See the command for details on creating MariaDB user accounts.
It's also possible to use option files (or configuration files) to set these options. Most clients read option files. Usually, starting a client with the --help option will display which files it looks for as well as which option groups it recognizes.
This page is licensed: CC BY-SA / Gnu FDL
mariadbpassword-ppassword-pThe database name is provided as the first argument after all the options, in this case database_name.
It will connect with the default tcp_ip port, 3306
MEMORY. Shared-memory connection to the local server on Windows systems only.
GRANT. This is useful if you lost your root password.CA directory (check OpenSSL docs, implies --ssl).
mariadb -h 166.78.144.191 -u username -ppassword database_name--host=name
-h name--password[=passwd]
-p[passwd]--pipe
-W--port=num
-P num--protocol=name--shared-memory-base-name=name--socket=name
-S name--ssl--ssl-ca=name--ssl-capath=name--ssl-cert=name--ssl-cipher=name--ssl-key=name--ssl-crl=name--ssl-crlpath=name--ssl-verify-server-cert--user=name
-u nameWEBINAR
MariaDB 101: Learning the Basics of MariaDB