MariaDB – add a new user and allow access to database

Posted on 2018-11-10 | by johniax

sudo mariadb -e 'CREATE DATABASE dbname'
sudo mariadb -e 'CREATE USER username IDENTIFIED BY "thePassword"'
sudo mariadb -e 'GRANT ALL ON dbname.* TO username'
sudo mariadb -e 'FLUSH PRIVILEGES'