![]() ![]() ssl-verify-server-cert -ssl-verify-server-cert ssl-crlpath -ssl-crlpath=nameĬertificate revocation list path (implies -ssl). ssl-crl -ssl-crl=nameĬertificate revocation list (implies -ssl). ssl-capath -ssl-capath=nameĬA directory (check OpenSSL docs, implies -ssl). Disable with ' -skip-ssl' ssl-ca -ssl-ca=nameĬA file in PEM format (check OpenSSL docs, implies -ssl). ssl -sslĮnable TLS for connection (automatically enabled with other TLS flags). See Secure Connections Overview and TLS System Variables for more detail. TLS OptionsĪ brief listing is provided below. socket -socket=nameįor 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). The value is case-sensitive, and defaults to MARIADB. 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. ![]() Shared-memory connection to the local server on Windows systems only. A named-pipe connection (either local or remote). SOCKET: A Unix socket file connection, available to the local server on Unix systems only.TCP: A TCP/IP connection to a server (either local or remote).For example on Unix, a Unix socket file ( SOCKET) is the default protocol, and usually results in the quickest connection. Usually you would not want to change this from the default. It can be one of TCP, SOCKET, PIPE or MEMORY (case-insensitive). Specifies the protocol to be used for the connection for the connection. The TCP/IP port number to use for the connection. 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. If you include the -p or -password option, but leave out the password, you will be prompted for it, which is more secure. 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. By default, MariaDB does not permit remote logins - see Configuring MariaDB for Remote Client Access. The database name is provided as the first argument after all the options, in this case database_name.Ĭonnect to the MariaDB server on the given host.If you include the -p option, but leave out the password, you will be prompted for it, which is more secure. It is also not secure to use a password in this way, as other users on the system can see it as part of the command that has been run. Note that for passwords, unlike the other parameters, there cannot be a space between the option ( -p) and the value ( password). -u specifies a user name, in this case username.Instead of using localhost, the IP 166.78.144.191 is used. For example: mariadb -h 166.78.144.191 -u username -ppassword database_name These defaults can be overridden by specifying a particular parameter to use. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |