MySQL/MariaDB

Run a SQL file

mariadb databasename < file.sql

Create a user with a role in a DB

CREATE USER "user"@"localhost" IDENTIFIED BY "password";
GRANT ALL PRIVILEGES ON databasename.* TO "user"@"localhost";