snippetbashTip

mariadb — The mariadb client tool. More information: <https://mariadb.com/docs/server/clients-and-utilities/ma

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

themariadbcommandclientclitoolmore

Problem

How to use the mariadb command: The mariadb client tool. More information: <https://mariadb.com/docs/server/clients-and-utilities/mariadb-client/mariadb-command-line-client>.

Solution

mariadb — The mariadb client tool. More information: <https://mariadb.com/docs/server/clients-and-utilities/mariadb-client/mariadb-command-line-client>.

Connect to a specific MariaDB database:

mariadb {{db_name}}

Connect to a specific MariaDB database using username and password:

mariadb {{[-u|--user]}} {{user_name}} {{[-p|--password]}} {{your_password}} {{db_name}}

Show warnings after every statement in interactive and batch mode:

mariadb --show-warning

Display less verbose outputs (can be used multiple times to produce less output):

mariadb {{-s|-ss|-sss|--silent}}

Execute SQL statements from a script file:

mariadb < {{path/to/script.sql}} {{db_name}} > {{path/to/output.tab}}

Check memory and open file usage at exit:

mariadb --debug-check

Connect using a socket file for local connections:

mariadb {{[-S|--socket]}} {{path/to/socket_name}}

Display help:

mariadb {{[-?|--help]}}

Code Snippets

Connect to a specific MariaDB database

mariadb {{db_name}}

Connect to a specific MariaDB database using username and password

mariadb {{[-u|--user]}} {{user_name}} {{[-p|--password]}} {{your_password}} {{db_name}}

Show warnings after every statement in interactive and batch mode

mariadb --show-warning

Display less verbose outputs (can be used multiple times to produce less output)

mariadb {{-s|-ss|-sss|--silent}}

Execute SQL statements from a script file

mariadb < {{path/to/script.sql}} {{db_name}} > {{path/to/output.tab}}

Context

tldr-pages: common/mariadb

Revisions (0)

No revisions yet.