Manajemen Database dan User MySQL/MariaDB CentOS 7

Create User:

create user ‘user’@’localhost’ identified by ‘password’;

Create Database:

create database monitoring;

Assign user to database monitoring:

grant all privileges on monitoring . * to ‘user’@’localhost’;

monitoring adalah: nama databasenya, * berarti semua table nya

Terakhir: flush privileges;

Notes:

GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@’localhost’;

REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;

DROP USER ‘demo’@‘localhost’;