Membuat user mariadb
CREATE USER foo2@test IDENTIFIED BY 'mariadb';
MariaDB [(none)]> CREATE USER userdb@localhost IDENTIFIED BY 'mariadbPass'; Query OK, 0 rows affected (0,002 sec)
Memberikan priviledge kepada user
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO userdb@localhost; Query OK, 0 rows affected (0,001 sec) MariaDB [(none)]>
Menghapus User mariadb
MariaDB [(none)]> DROP USER userdb@localhost; Query OK, 0 rows affected (0,002 sec)