Renungan Indah - karya WS Rendra

Seringkali aku berkata,
Ketika semua orang memuji milikku
Bahwa sesungguhnya ini
hanyalah titipan

Bahwa mobilku hanyalah titipan-Nya
Bahwa rumahku hanyalah titipan-Nya
Bahwa hartaku hanyalah titipan-Nya
Bahwa putraku hanyalah titipan-Nya
Tetapi, mengapa aku tak pernah bertanya: mengapa Dia menitipkan padaku???

Untuk apa Dia menitipkan ini padaku ???
Dan kalau bukan milikku, apa yang harus kulakukan untuk milik-Nya itu ???...
Adakah aku memiliki hak atas sesuatu yang bukan milikku?
Mengapa hatiku justru terasa berat, ketika titipan itu diminta kembali oleh-Nya ?

Ketika diminta kembali, kusebut itu sebagai musibah,
kusebut itu sebagai ujian, kusebut itu sebagai petaka,
kusebut dengan panggilan apa saja untuk melukiskan bahwa itu adalah derita.

Ketika aku berdoa, kuminta titipan yang cocok dengan hawa nafsuku, aku ingin lebih banyak harta, ingin lebih banyak mobil, lebih banyak rumah, lebih banyak popularitas, dan kutolak sakit, kutolak kemiskinan.

Seolah semua “derita” adalah hukuman bagiku. Seolah keadilan dan kasih-Nya harus berjalan seperti matematika: aku rajin beribadah, maka selayaknyalah derita menjauh dariku, dan nikmat dunia kerap menghampiriku.

Kuperlakukan Dia seolah mitra dagang, dan bukan Kekasih. Kuminta Dia membalas “perlakuan baikku”, dan menolak keputusan-Nya yang tak sesuai keinginanku,
Gusti, padahal tiap hari kuucapkan, hidup dan matiku hanyalah untuk beribadah… “ketika langit dan bumi bersatu, bencana dan keberuntungan sama saja.” 

Syntax lengkap membuat database menggunakan xampp

ini adalah script syntax yg saya gunakan untuk membuat database gaji (db_gaji) dimana di dalam data base tsb trdpat 5 tabel dgn 5 data yg di entrykan,  juga terdapat 5 user dengan hak akses ke masing-masing tabel . silahkan di modifikasi sesuai kebutuhan,

 Maaf saya tidak merapikan tampilan table nya, saya rasa jika anda mengikuti script nya anda akan mudah paham dan bisa melihat langsung hasilnya di komputer anda. mengenai cara instalasi xampp nya saya lihat sudah banyak yg menjelaskan, silahkan googling, tinggalkan komentar atau tautan anda jika suka, Terima kasih... ^_^

Start - run - cmd - ketik : cd \ - enter


C:

C:\>cd xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| akademik           |
| cdcol              |
| mysql              |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql> create database db_gaji;
Query OK, 1 row affected (0.05 sec)

mysql> use db_gaji;
Database changed
mysql> create table karyawan(
    -> nik varchar(10) primary key not null,
    -> nama varchar(30) not null,
    -> jabatan varchar(15) not null );
Query OK, 0 rows affected (0.09 sec)

mysql> desc karyawan;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| nik     | varchar(10) | NO   | PRI | NULL    |       |
| nama    | varchar(30) | NO   |     | NULL    |       |
| jabatan | varchar(15) | NO   |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> alter table karyawan
    -> add departemen varchar(20),
    -> add alamat text,
    -> add telepon varchar(20);
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc karyawan
    -> ;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| nik        | varchar(10) | NO   | PRI | NULL    |       |
| nama       | varchar(30) | NO   |     | NULL    |       |
| jabatan    | varchar(15) | NO   |     | NULL    |       |
| departemen | varchar(20) | YES  |     | NULL    |       |
| alamat     | text        | YES  |     | NULL    |       |
| telepon    | varchar(20) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> alter table karyawan
    -> add tgl_lahir varchar(20)not null,
    -> add status varchar(10) not null,
    -> add start_date date ;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc karyawan;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| nik        | varchar(10) | NO   | PRI | NULL    |       |
| nama       | varchar(30) | NO   |     | NULL    |       |
| jabatan    | varchar(15) | NO   |     | NULL    |       |
| departemen | varchar(20) | YES  |     | NULL    |       |
| alamat     | text        | YES  |     | NULL    |       |
| telepon    | varchar(20) | YES  |     | NULL    |       |
| tgl_lahir  | varchar(20) | NO   |     | NULL    |       |
| status     | varchar(10) | NO   |     | NULL    |       |
| start_date | date        | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
9 rows in set (0.01 sec)

mysql> create table departemen(
    -> nama_departemen varchar(20) primary key not null,
    -> kepala_departemen varchar(30) not null,
    -> jumlah_karyawan varchar (10) not null );
Query OK, 0 rows affected (0.06 sec)

mysql> desc departemen;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| nama_departemen   | varchar(20) | NO   | PRI | NULL    |       |
| kepala_departemen | varchar(30) | NO   |     | NULL    |       |
| jumlah_karyawan   | varchar(10) | NO   |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+
3 rows in set (0.03 sec)

mysql> create table gaji(
    -> kode_kontrak varchar(20) primary key not null,
    -> nama varchar(30) not null,
    -> departemen varchar(20) not null,
    -> gaji varchar(10) not null,
    -> golongan varchar(5) );
Query OK, 0 rows affected (0.06 sec)

mysql> desc gaji;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| kode_kontrak | varchar(20) | NO   | PRI | NULL    |       |
| nama         | varchar(30) | NO   |     | NULL    |       |
| departemen   | varchar(20) | NO   |     | NULL    |       |
| gaji         | varchar(10) | NO   |     | NULL    |       |
| golongan     | varchar(5)  | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.03 sec)

mysql> create table presensi(
    -> nik varchar(10) primary key not null,
    -> nama varchar(30) not null,
    -> hari_masuk varchar(2) not null,
    -> hari_absen varchar(2) not null,
    -> hari_ijin varchar(2) not null,
    -> hari_sakit varchar(2) not null );
Query OK, 0 rows affected (0.07 sec)

mysql> desc presensi;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| nik        | varchar(10) | NO   | PRI | NULL    |       |
| nama       | varchar(30) | NO   |     | NULL    |       |
| hari_masuk | varchar(2)  | NO   |     | NULL    |       |
| hari_absen | varchar(2)  | NO   |     | NULL    |       |
| hari_ijin  | varchar(2)  | NO   |     | NULL    |       |
| hari_sakit | varchar(2)  | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> create table penyesuaian(
    -> nik varchar(10) primary key not null,
    -> bonus varchar(10),
    -> potongan varchar(10),
    -> tunjangan varchar(10),
    -> thr varchar(10),
    -> promosi varchar(10),
    -> asuransi varchar(10),
    -> jamsostek varchar(10));
Query OK, 0 rows affected (0.06 sec)

mysql> desc penyesuaian;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| nik       | varchar(10) | NO   | PRI | NULL    |       |
| bonus     | varchar(10) | YES  |     | NULL    |       |
| potongan  | varchar(10) | YES  |     | NULL    |       |
| tunjangan | varchar(10) | YES  |     | NULL    |       |
| thr       | varchar(10) | YES  |     | NULL    |       |
| promosi   | varchar(10) | YES  |     | NULL    |       |
| asuransi  | varchar(10) | YES  |     | NULL    |       |
| jamsostek | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
8 rows in set (0.01 sec)

mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| departemen        |
| gaji              |
| karyawan          |
| penyesuaian       |
| presensi          |
+-------------------+
5 rows in set (0.01 sec)

mysql> desc departemen;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| nama_departemen   | varchar(20) | NO   | PRI | NULL    |       |
| kepala_departemen | varchar(30) | NO   |     | NULL    |       |
| jumlah_karyawan   | varchar(10) | NO   |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> insert into departemen
    -> values
    -> ('keuangan','eby','6');
Query OK, 1 row affected (0.01 sec)

mysql> select * from departemen;
+-----------------+-------------------+-----------------+
| nama_departemen | kepala_departemen | jumlah_karyawan |
+-----------------+-------------------+-----------------+
| keuangan        | eby               | 6               |
+-----------------+-------------------+-----------------+
1 row in set (0.00 sec)

mysql> insert into departemen
    -> values
    -> ('produksi','burhan','100');
Query OK, 1 row affected (0.00 sec)

mysql> insert into departemen
    -> values
    -> ('logistik','mardan','20');
Query OK, 1 row affected (0.00 sec)

mysql> insert into departemen
    -> values
    -> ('hrd','taufik hidayat','4');
Query OK, 1 row affected (0.00 sec)

mysql> insert into departemen
    -> values
    -> ('marketing','i gde','14');
Query OK, 1 row affected (0.00 sec)

mysql> select * from departemen;
+-----------------+-------------------+-----------------+
| nama_departemen | kepala_departemen | jumlah_karyawan |
+-----------------+-------------------+-----------------+
| keuangan        | eby               | 6               |
| produksi        | burhan            | 100             |
| logistik        | mardan            | 20              |
| hrd             | taufik hidayat    | 4               |
| marketing       | i gde             | 14              |
+-----------------+-------------------+-----------------+
5 rows in set (0.00 sec)

mysql> desc karyawan;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| nik        | varchar(10) | NO   | PRI | NULL    |       |
| nama       | varchar(30) | NO   |     | NULL    |       |
| jabatan    | varchar(15) | NO   |     | NULL    |       |
| departemen | varchar(20) | YES  |     | NULL    |       |
| alamat     | text        | YES  |     | NULL    |       |
| telepon    | varchar(20) | YES  |     | NULL    |       |
| tgl_lahir  | varchar(20) | NO   |     | NULL    |       |
| status     | varchar(10) | NO   |     | NULL    |       |
| start_date | date        | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
9 rows in set (0.01 sec)

mysql> select * from gaji;
Empty set (0.00 sec)

mysql> insert into gaji
    -> values
    -> ('2010/01a','eby','keuangan','7500000','5b');
Query OK, 1 row affected (0.00 sec)

mysql> select * from gaji;
+--------------+------+------------+---------+----------+
| kode_kontrak | nama | departemen | gaji    | golongan |
+--------------+------+------------+---------+----------+
| 2010/01a     | eby  | keuangan   | 7500000 | 5b       |
+--------------+------+------------+---------+----------+
1 row in set (0.00 sec)

mysql> insert into gaji
    -> values
    -> ('2010/01b','burhan','produksi','6500000','4b');
Query OK, 1 row affected (0.01 sec)

mysql> insert into gaji
    -> values
    -> ('2010/01c','mardan','logistik','7500000','5a');
Query OK, 1 row affected (0.00 sec)

mysql> insert into gaji
    -> values
    -> ('2010/01d','taufik hidayat','hrd','17500000','7a');
Query OK, 1 row affected (0.00 sec)

mysql> insert into gaji
    -> values
    -> ('2010/01e','i gde','marketing','7500000','5a');
Query OK, 1 row affected (0.00 sec)

mysql> select * from gaji;
+--------------+----------------+------------+----------+----------+
| kode_kontrak | nama           | departemen | gaji     | golongan |
+--------------+----------------+------------+----------+----------+
| 2010/01a     | eby            | keuangan   | 7500000  | 5b       |
| 2010/01b     | burhan         | produksi   | 6500000  | 4b       |
| 2010/01c     | mardan         | logistik   | 7500000  | 5a       |
| 2010/01d     | taufik hidayat | hrd        | 17500000 | 7a       |
| 2010/01e     | i gde          | marketing  | 7500000  | 5a       |
+--------------+----------------+------------+----------+----------+
5 rows in set (0.00 sec)

mysql> desc penyesuaian;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| nik       | varchar(10) | NO   | PRI | NULL    |       |
| bonus     | varchar(10) | YES  |     | NULL    |       |
| potongan  | varchar(10) | YES  |     | NULL    |       |
| tunjangan | varchar(10) | YES  |     | NULL    |       |
| thr       | varchar(10) | YES  |     | NULL    |       |
| promosi   | varchar(10) | YES  |     | NULL    |       |
| asuransi  | varchar(10) | YES  |     | NULL    |       |
| jamsostek | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
8 rows in set (0.01 sec)

mysql> insert into penyesuaian
    -> values
    -> ('2010/01a','0','500000','200000','0','0','100000','20000');
Query OK, 1 row affected (0.00 sec)

mysql> insert into penyesuaian
    -> values
    -> ('2010/01b','0','500000','200000','0','0','100000','20000');
Query OK, 1 row affected (0.00 sec)

mysql> insert into penyesuaian
    -> values
    -> ('2010/01c','0','500000','300000','0','0','400000','20000');
Query OK, 1 row affected (0.00 sec)

mysql> insert into penyesuaian
    -> values
    -> ('2010/01d','0','500000','400000','0','0','400000','20000');
Query OK, 1 row affected (0.00 sec)

mysql> insert into penyesuaian
    -> values
    -> ('2010/01e','800000','700000','400000','0','0','400000','20000');
Query OK, 1 row affected (0.00 sec)

mysql> select * from penyesuaian;
+----------+--------+----------+-----------+------+---------+----------+-----------+
| nik      | bonus  | potongan | tunjangan | thr  | promosi | asuransi | jamsostek |
+----------+--------+----------+-----------+------+---------+----------+-----------+
| 2010/01a | 0      | 500000   | 200000    | 0    | 0       | 100000   | 20000     |
| 2010/01b | 0      | 500000   | 200000    | 0    | 0       | 100000   | 20000     |
| 2010/01c | 0      | 500000   | 300000    | 0    | 0       | 400000   | 20000     |
| 2010/01d | 0      | 500000   | 400000    | 0    | 0       | 400000   | 20000     |
| 2010/01e | 800000 | 700000   | 400000    | 0    | 0       | 400000   | 20000     |
+----------+--------+----------+-----------+------+---------+----------+-----------+
5 rows in set (0.00 sec)

mysql> desc presensi;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| nik        | varchar(10) | NO   | PRI | NULL    |       |
| nama       | varchar(30) | NO   |     | NULL    |       |
| hari_masuk | varchar(2)  | NO   |     | NULL    |       |
| hari_absen | varchar(2)  | NO   |     | NULL    |       |
| hari_ijin  | varchar(2)  | NO   |     | NULL    |       |
| hari_sakit | varchar(2)  | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> insert into presensi
    -> values
    -> ('2010/01a','eby','20','1','1','0');
Query OK, 1 row affected (0.00 sec)

mysql> select * from presensi;
+----------+------+------------+------------+-----------+------------+
| nik      | nama | hari_masuk | hari_absen | hari_ijin | hari_sakit |
+----------+------+------------+------------+-----------+------------+
| 2010/01a | eby  | 20         | 1          | 1         | 0          |
+----------+------+------------+------------+-----------+------------+
1 row in set (0.00 sec)

mysql> insert into presensi
    -> values
    -> ('2010/01b','burhan','22','0','0','6');
Query OK, 1 row affected (0.00 sec)

mysql> insert into presensi
    -> values
    -> ('2010/01c','mardan','10','10','5','5');
Query OK, 1 row affected (0.00 sec)

mysql> insert into presensi
    -> values
    -> ('2010/01d','taufik hidayat','30','0','0','0');
Query OK, 1 row affected (0.00 sec)

mysql> insert into presensi
    -> values
    -> ('2010/01e','i gde','20','5','5','0');
Query OK, 1 row affected (0.00 sec)

mysql> select * from presensi;
+----------+----------------+------------+------------+-----------+------------+
| nik      | nama           | hari_masuk | hari_absen | hari_ijin | hari_sakit |
+----------+----------------+------------+------------+-----------+------------+
| 2010/01a | eby            | 20         | 1          | 1         | 0          |
| 2010/01b | burhan         | 22         | 0          | 0         | 6          |
| 2010/01c | mardan         | 10         | 10         | 5         | 5          |
| 2010/01d | taufik hidayat | 30         | 0          | 0         | 0          |
| 2010/01e | i gde          | 20         | 5          | 5         | 0          |
+----------+----------------+------------+------------+-----------+------------+

5 rows in set (0.00 sec)

mysql> select * from karyawan;
+---------+----------------+-----------------+------------+--------+---------+------------+---------+------------+
| nik     | nama           | jabatan         | departemen | alamat | telepon | tgl_lahir  | status  | start_date |
+---------+----------------+-----------------+------------+--------+---------+------------+---------+------------+
| 2010/01 | eby            | finance         | keuangan   |        |         | 1945-12-31 | single  | 2005-05-03 |
| 2010/02 | burhan         | mandor kawat    | produksi   |        |         | 1935-12-31 | single  | 2004-05-03 |
| 2010/03 | mardan         | kepala logistik | logistik   |        |         | 1925-12-31 | married | 2002-05-03 |
| 2010/04 | taufik hidayat | hrd manager     | hrd        |        |         | 1906-12-31 | married | 1998-05-03 |
| 2010/05 | i gde          | marketing manag | marketing  |        |         | 1902-12-31 | married | 1996-05-03 |
+---------+----------------+-----------------+------------+--------+---------+------------+---------+------------+
5 rows in set (0.00 sec)

mysql> select * from departemen;
+-----------------+-------------------+-----------------+
| nama_departemen | kepala_departemen | jumlah_karyawan |
+-----------------+-------------------+-----------------+
| keuangan        | eby               | 6               |
| produksi        | burhan            | 100             |
| logistik        | mardan            | 20              |
| hrd             | taufik hidayat    | 4               |
| marketing       | i gde             | 14              |
+-----------------+-------------------+-----------------+
5 rows in set (0.01 sec)

mysql> select * from gaji;
+--------------+----------------+------------+----------+----------+
| kode_kontrak | nama           | departemen | gaji     | golongan |
+--------------+----------------+------------+----------+----------+
| 2010/01a     | eby            | keuangan   | 7500000  | 5b       |
| 2010/01b     | burhan         | produksi   | 6500000  | 4b       |
| 2010/01c     | mardan         | logistik   | 7500000  | 5a       |
| 2010/01d     | taufik hidayat | hrd        | 17500000 | 7a       |
| 2010/01e     | i gde          | marketing  | 7500000  | 5a       |
+--------------+----------------+------------+----------+----------+
5 rows in set (0.00 sec)

mysql> select * from penyesuaian;
+----------+--------+----------+-----------+------+---------+----------+-----------+
| nik      | bonus  | potongan | tunjangan | thr  | promosi | asuransi | jamsostek |
+----------+--------+----------+-----------+------+---------+----------+-----------+
| 2010/01a | 0      | 500000   | 200000    | 0    | 0       | 100000   | 20000     |
| 2010/01b | 0      | 500000   | 200000    | 0    | 0       | 100000   | 20000     |
| 2010/01c | 0      | 500000   | 300000    | 0    | 0       | 400000   | 20000     |
| 2010/01d | 0      | 500000   | 400000    | 0    | 0       | 400000   | 20000     |
| 2010/01e | 800000 | 700000   | 400000    | 0    | 0       | 400000   | 20000     |
+----------+--------+----------+-----------+------+---------+----------+-----------+
5 rows in set (0.01 sec)

mysql> create table user(
    -> username varchar(10) primary key not null,
    -> password varchar(6) not null,
    -> nama varchar(30) not null );
Query OK, 0 rows affected (0.04 sec)

mysql> desc user;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(10) | NO   | PRI | NULL    |       |
| password | varchar(6)  | NO   |     | NULL    |       |
| nama     | varchar(30) | NO   |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> insert into user
    -> values
    -> ('user123','user123','eby');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into user
    -> values
    -> ('user234','user123','burhan');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into user
    -> values
    -> ('user345','user123','mardan');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into user
    -> values
    -> ('user456','user123','taufik hidayat');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into user
    -> values
    -> ('user567','user123','i gde');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from user;
+----------+----------+----------------+
| username | password | nama           |
+----------+----------+----------------+
| user123  | user12   | eby            |
| user234  | user12   | burhan         |
| user345  | user12   | mardan         |
| user456  | user12   | taufik hidayat |
| user567  | user12   | i gde          |
+----------+----------+----------------+
5 rows in set (0.00 sec)
================================================================================
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| akademik           |
| cdcol              |
| db_gaji            |
| mysql              |
| phpmyadmin         |
| test               |
+--------------------+
7 rows in set (0.00 sec)

mysql> use db_gaji;
Database changed
mysql> grant select,insert,update,delete,create,drop,index,alter on db_gaji
    -> to taufikhidayat identified by 'cyberbear';
Query OK, 0 rows affected (0.00 sec)

mysql> select * from user;
+-----------+----------+----------------+
| username  | password | nama           |
+-----------+----------+----------------+
| finance   | 123456   | eby            |
| produksi  | 123456   | burhan         |
| logistik  | 123456   | mardan         |
| hrd       | 123456   | taufik hidayat |
| marketing | 123456   | i gde          |
+-----------+----------+----------------+
5 rows in set (0.01 sec)

mysql> grant select,insert,update,index,alter on karyawan
    -> to finance identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,index,alter on gaji
    -> to finance identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,index,alter on penyesuaian
    -> to finance identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> alter table user add akses varchar(40);
Query OK, 5 rows affected (0.12 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> desc user;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(10) | NO   | PRI | NULL    |       |
| password | varchar(6)  | NO   |     | NULL    |       |
| nama     | varchar(30) | NO   |     | NULL    |       |
| akses    | varchar(40) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.02 sec)

mysql> desc user;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(10) | NO   | PRI | NULL    |       |
| password | varchar(6)  | NO   |     | NULL    |       |
| nama     | varchar(30) | NO   |     | NULL    |       |
| akses    | varchar(40) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> select * from user;
+-----------+----------+----------------+---------------------------+
| username  | password | nama           | akses                     |
+-----------+----------+----------------+---------------------------+
| finance   | 123456   | eby            | gaji,penyesuaian,karyawan |
| produksi  | 123456   | burhan         | NULL                      |
| logistik  | 123456   | mardan         | NULL                      |
| hrd       | 123456   | taufik hidayat | NULL                      |
| marketing | 123456   | i gde          | NULL                      |
+-----------+----------+----------------+---------------------------+
5 rows in set (0.00 sec)

mysql> select * from user;
+-----------+----------+----------------+------------------------------------------+
| username  | password | nama           | akses                       |
+-----------+----------+----------------+------------------------------------------+
| finance   | 123456   | eby            | gaji,penyesuaian,karyawan,presensi       |
| produksi  | 123456   | burhan         | karyawan,presensi,departemen            |
| logistik  | 123456   | mardan         | karyawan,presensi,departemen             |
| hrd       | 123456   | taufik hidayat | gaji,penyesuaian,karyawan,presensi,depar |
| marketing | 123456   | i gde          | karyawan,presensi,departemen           |
+-----------+----------+----------------+------------------------------------------+
5 rows in set (0.00 sec)

mysql> grant select on karyawan to produksi identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,update on presensi to produksi identified by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> grant select on departemen to produksi identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on karyawan to logistik identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on departemen to logistik identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,update on presensi to logistik identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,update on presensi to marketing identified by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> grant select on departemen to marketing identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on karyawan to marketing identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on departemen to marketing identified by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> grant select on departemen to logistik identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on departemen to produksi identified by '123456';
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create,drop,index,alter on gaji to hrd
identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create,drop,index,alter on karyawan to
hrd identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create,drop,index,alter on penyesuaian
to hrd identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create,drop,index,alter on presensi to
hrd identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete,create,drop,index,alter on user to hrd
identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> select host,user from mysql.user;
+-----------+---------------+
| host      | user          |
+-----------+---------------+
| %         | finance       |
| %         | hrd           |
| %         | logistik      |
| %         | marketing     |
| %         | produksi      |
| %         | taufikhidayat |
| %         | user123       |
| localhost | pma           |
| localhost | root          |
+-----------+---------------+
9 rows in set (0.00 sec)

mysql> quit
bye
===================================================================

C:\xampp\mysql\bin>mysql -u logistik -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 92
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db_gaji            |
+--------------------+
2 rows in set (0.00 sec)

mysql> use db_gaji;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| departemen        |
| karyawan          |
| presensi          |
+-------------------+
3 rows in set (0.00 sec)

mysql> quit
Bye
===============================================================================
C:\xampp\mysql\bin>mysql -u finance -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 93
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_gaji;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| gaji              |
| karyawan          |
| penyesuaian       |
+-------------------+
3 rows in set (0.00 sec)

mysql> quit
Bye
==================================================================================
C:\xampp\mysql\bin>mysql -u produksi -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 94
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_gaji;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| departemen        |
| karyawan          |
| presensi          |
+-------------------+
3 rows in set (0.00 sec)

mysql> quit
Bye
===================================================================================
C:\xampp\mysql\bin>mysql -u hrd -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 95
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_gaji;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| departemen        |
| gaji              |
| karyawan          |
| penyesuaian       |
| presensi          |
| user              |
+-------------------+
6 rows in set (0.00 sec)

mysql> quit
Bye
=====================================================================================
C:\xampp\mysql\bin>mysql -u marketing -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 96
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_gaji;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_db_gaji |
+-------------------+
| departemen        |
| karyawan          |
| presensi          |
+-------------------+
3 rows in set (0.00 sec)

mysql> alter table karyawan
    -> add email varchar(20);
ERROR 1142 (42000): ALTER command denied to user 'marketing'@'localhost' for tab
le 'karyawan'
( error diatas di sebabkan user (marketing) tidak memiliki akses untuk mengalter database,user hanya memiliki akses untuk "view" seperti yg telah kita buat hak akses nya diatas)
mysql>