Database MySql

 show databases

 

2.      

Use mysql

     Show tables

4.      

Show privilages

5.      
Show create table user

6.      
Select *from user

      7.  create user 'nama_user'@'host'

      8.       lalu ctrl+enter select *from user(gambar sama no.7

      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','fikri','1234','Y','Y','Y','Y','Y');

 

      11.   lalu ctrl+enter select *from user(gambar sama no.7)

      12.   show grants for 'nama_user'@'host (emang tidak bisa karena grant tidak ada)

      13.  grant create, select, insert, delete, update on *.* to 'nama_user'@'host' identified by '1234'