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>
2 komentar:
makasih mas...
wahhh.. side kmana aja ko ?
Posting Komentar