Membuat User dan Grant Akses User di MySQL DB CLI

Membuat User dan Grant Akses User di MySQL DB CLI

Akses MySQL via linux command line, ketik command di bawah kemudian masukan password:

mysql -u root -p

Membuat user baru di MySQL DB via Command Line Interface:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Grant access dari user yang baru di buat ke database yang sudah ada:

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

Setelah itu ketik command di bawah untuk melihat effeknya:

FLUSH PRIVILEGES;

 

Berikut adalah beberapa perbedaan grant akses user:

  • ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the system)
  • CREATE- allows them to create new tables or databases
  • DROP- allows them to them to delete tables or databases
  • DELETE- allows them to delete rows from tables
  • INSERT- allows them to insert rows into tables
  • SELECT- allows them to use the Select command to read through databases
  • UPDATE- allow them to update table rows
  • GRANT OPTION- allows them to grant or remove other users' privileges

To provide a specific user with a permission, you can use this framework:

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

Berikut adalah cara untuk merevoke user permission:

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

Berikut adalah cara untuk drop database:

DROP USER ‘demo’@‘localhost’;