MariaDB [(none)]> CREATE USER pryrt@localhost IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.015 sec)

MariaDB [(none)]> CREATE DATABASE test_db;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON test_db.* TO pryrt@localhost IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.014 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit
Bye