بسم الله
Bismillah
Command line how to create database, user and password mariadb or mysql with grant all privileges
First you must login into mysql/mariadb command line
mysql -u root
If you never set login command line without root, you can read Yang Dilakukan Setelah Install Ulang GNU/Linux
sudo mysql -u root
Create DB database
create database db_blogs;
Create User and Password database
create user 'blog_user'@'localhost' identified by 'blog_user!@#';
Set user get all privileges on database
grant all privileges on db_blogs.* to 'blog_user'@'localhost';
Flush
flush privileges;
الحمد لله