commands.sh

mariadb

all

The mariadb client tool.

More info →

Options (3)

-u, --userboolean

Connect to a specific MariaDB database using username and password

Example: mariadb {{[-u|--user]}} {{user_name}} {{[-p|--password]}} {{your_password}} {{db_name}}
-p, --passwordboolean

Connect to a specific MariaDB database using username and password

Example: mariadb {{[-u|--user]}} {{user_name}} {{[-p|--password]}} {{your_password}} {{db_name}}
-S, --socketboolean

Connect using a socket file for local connections

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

Examples (8)

Connect to MariaDB as the current user

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
made by @shridhargupta | data from tldr-pages