create table auto( autoID int not null primary key AUTO_INCREMENT, mudel varchar(20), mark varchar(20), varv varchar(10), v_aasta int); SELECT * from auto;INSERT INTO `auto` (`autoID`, `mudel`, `mark`, `varv`, `v_aasta`) VALUES (NULL, ‘X5’, ‘BMW’, ‘valge’, ‘2000’);CREATE USER ‘opilaneKemppi’@’localhost’ IDENTIFIED VIA mysql_native_password USING ‘***’;GRANT USAGE ON *.* TO ‘opilaneKemppi’@’localhost’ REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; CREATE
USER
‘opilaneKemppi’@’localhost’GRANT USAGE ON *.* TO ‘opilaneKemppi’@’localhost’GRANT – назначение прав пользователяGRANT SELECT ON `autod_kemppi`.`auto` TO ‘opilaneKemppi’@’localhost’; Create table klient( klientID int PRIMARY KEY AUTO_INCREMENT, eesnimi varchar(10), perenimi varchar(10) not null, telefon char(12) )Use autod_kemppi;insert into klient(eesnimi,perenimi)VALUES (‘test’,’test’);Insert into auto(mudel, mark, varv, v_aasta) values (‘x1’,‘Volvo’,‘sinine’,2003) Security -> Login(New Login)