nama : Ilham taufiq
nim : 22255601012
kelas : Pengembangan Perangkat Lunak
materi : Database SQL
CREATE DATABASE dblatihan ;
SHOW DATABASES ;
CREATE USER 'bedu'@'localhost' IDENTIFIED BY 'bedu';
SELECT user, host, password FROM mysql.user;
GRANT ALL PRIVILEGES ON dblatihan.* TO 'bedu'@'localhost' ;
SHOW GRANTS FOR 'bedu'@'localhost' ;
mysql -u bedu dblatihan -p
Enter password : bedu
CREATE TABLE mahasantri (
id INT PRIMARY KEY AUTO_INCREMENT,
nama VARCHAR(45) NOT NULL,
asal VARCHAR(45) NOT NULL,
gender CHAR(1) NOT NULL,
jurusan VARCHAR(45) NOT NULL
);
SHOW TABLES ;
INSERT INTO mahasantri (nama, asal, gender, jurusan) VALUES
('Ilham Taufiq', 'Denpasar', 'L', 'Pengembangan Perangkat Lunak'),
('Hanif Al Faruq', 'Bogor', 'L', 'Pengembangan Perangkat Lunak'),
('Muhammad Rifandy', 'Medan', 'L', 'Pengembangan Perangkat Lunak'),
('Nugi Bagas', 'Palembang', 'L', 'Digital Marketing'),
('Ilham Afif', 'Palembang', 'L', 'Digital Marketing'),
('Muhammad Omardy', 'Palembang', 'L', 'Digital Marketing')
;
SELECT * FROM mahasantri ;
DROP TABLE mahasantri ;
CREATE DATABASE dbpegawai ;
SHOW DATABASES ;
CREATE USER 'ucup'@'localhost' IDENTIFIED BY 'ucup' ;
SELECT user, host, password FROM mysql.user;
GRANT ALL PRIVILEGES ON dbpegawai.* TO 'ucup'@'localhost' ;
SHOW GRANTS FOR 'ucup'@'localhost' ;
mysql -u ucup dbpegawai -p
Enter password : ucup
CREATE TABLE pegawai (
id INT PRIMARY KEY AUTO_INCREMENT,
nama VARCHAR(45) NOT NULL,
gender CHAR(1) NOT NULL,
jabatan VARCHAR(45) NOT NULL,
gaji DOUBLE NOT NULL
);
SHOW TABLES ;
INSERT INTO pegawai (nama, gender, jabatan, gaji) VALUES
('Ilham Taufiq', 'L', 'Database Administrator', 20000000),
('Hanif Al Faruq', 'L', 'Database Designer', 15000000),
('Muhammad Rifandy', 'L', 'Programmer', 12000000),
('Nugi Bagas', 'L', 'Programmer', 12000000),
('Ilham Afif', 'L', 'Engineer', 7000000),
('Muhammad Omardy', 'L', 'Engineer', 7000000)
;
SELECT * FROM pegawai ;
DROP TABLE pegawai ;