Menggunakan MySQL / Mariadb dengan Sintax Command

•MariaDB [(none)]> grant all privileges on *.* to ’user’@’%’        

-> identified by ’kata_sandi’ with grant option;        

•MariaDB [(none)]> grant reload,process on *.* TO ’admin’@’localhost’;        

•MariaDB [(none)]> grant usage on *.* to ’dummy’@’localhost’;        

Cara lain:        

•$ mysql –user=root mysql        

•MariaDB [(none)]> insert into user        

-> values(’localhost’,’monty’,password(’kata_sandi’),        

-> ’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’);        

•MariaDB [(none)]> insert into user        

-> values(’ -> ’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’);        

•MariaDB [(none)]> insert into user set host=’localhost’, user=’admin’,