create database bank;
Untuk membuat 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
('man’,'Mandiri','Beji),
('bca','BCA','Sukmajaya'),
('bri','BRI','Lenteng Agung'),
('bni','BNI','Kemang'),
('bri','BRI','Sudirman');

insert into pegawai values
('man','Ramadhani','ramadhani.26@gmail.com'),
('bri','Fitrah','fitrah.26@gmail.com'),
('bca','Tarzky','tarzky.26@gmail.com'),
('bri','Punky','punku.26@gmail.com'),
('man','Brandy','brandy.26@gmail.com');

create user fitrah@localhost;
create user ramadhan@localhost;

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

mysql -u root
use mysql;
grant all privileges ON *.* TO fitrah@localhost with grant option;

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

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

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

mysql -u fitrah -p
drop database lat;