SBD

create database bank;
use bank;
create table bank(no_pegawai int(10), nama varchar(30), cabang varchar(30));
create table pegawai(no_pegawai int(10), nama_pegawai varchar(30), email varchar(30));

insert into bank values('123456','Mandiri','Tanjung Barat'),('123457','BCA','Kalimalang'),('123458','BRI','Lenteng Agung'),('123459','BNI','mampang'),('123450','BRI','Sudirman');
insert into pegawai values('123456','Ramadhan','Ramadhani@gmail.com'),('123457','Risky','risky.25@gmail.com'),('123458','Tarzky','tarzky.alif@gmail.com'),('123459','Punky','punku.25girl@gmail.com'),('123450','Brandy','brandycullen@gmail.com');
create user array@localhost;
create user riray@localhost;

use mysql;
select user, password from user;
grant select ON coba .* TO array;
exit;

mysql -u root
use mysql;
grant all privileges ON *.* TO array @localhost with grant option;
(memberi seluruh hak akses, *.* untuk seluruh database bserta tabel,
with grand option untuk mmberi hak akses ke user lain)

use mysql;
update user set password= PASSWORD ('123') where user='array' and host='localhost';
set password for array@localhost=password('123');
exit;

mysql -u array -p;
show databases;
drop database bank;
exit;

mysql -u root;
set password for array@localhost=password('123');
exit;

mysql -u array -p
drop database lat; (error krna sudah mencabut hak akses revoke)

*.* artinyaaa
databases (semuanya) . table



LA buat 2 buah user dan passwordnya