// On-Kamis, 10 September 2015
1.
Show datbases
2.
Use mysql;
3.
Show tables;
4.
Show privileges;
5.
Show create table user
6.
Select * from user
7.
Create user ‘nama_user’@’host’;
8.
Select * from user;
9.
Show grants for ‘nama_user’@’host’;
10.
insert into 'user' (host, user,
password,select_priv,insert_priv, update_priv,delete_priv, create_priv)
values ('host', 'nama_user', '1234', 'y',
'y', 'y', 'y', 'y');
11.
show grants for 'nama_user'@'host';
13.grant create, select, insert, delete,
update on *.* to 'nama_user'@'host' identified by '1234';
