Command Line to Create Mysql and Database and Grant All Permission

بسم الله 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; الحمد لله ...

September 24, 2021 · 1 min · Masari