The mariadb command

the MariaDB command-line tool (mysql is now a symlink to mariadb) 19 examples from the lessons of the IVski Linux Playground — try them in the terminal next to them.

Examples

sudo mariadb
mariadb
sudo mariadb -e "SHOW DATABASES"
sudo mariadb -e "CREATE DATABASE shop"
sudo mariadb shop -e "CREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, price DECIMAL(6,2))"
sudo mariadb shop -e "DESCRIBE products"
sudo mariadb shop -e "INSERT INTO products (name, price) VALUES ('Espresso', 1.80), ('Cappuccino', 2.60), ('Latte', 2.90)"
sudo mariadb shop -e "SELECT * FROM products"
sudo mariadb -e "SELECT user, host FROM mysql.user"
sudo mariadb -e "CREATE USER 'shop'@'localhost' IDENTIFIED BY 'S3cret-Pass'"
sudo mariadb -e "GRANT ALL PRIVILEGES ON shop.* TO 'shop'@'localhost'"
sudo mariadb -e "SHOW GRANTS FOR 'shop'@'localhost'"
mariadb -u shop -p shop
mariadb -u shop -pS3cret-Pass shop -e "SELECT * FROM products"
mariadb -u shop -pS3cret-Pass mysql
mariadb shop -e "SELECT COUNT(*) FROM products"
sudo mariadb -e "CREATE DATABASE shop_test"
sudo mariadb shop_test < ~/shop.sql
sudo mariadb shop_test -e "SELECT * FROM products"

Lessons that use mariadb