Daily Archives: 17.04.2023

LOCALHOST/SQL SERVER — KASUTAJAD JA ÕIGUSED

https://moodle.edu.ee/mod/assign/view.php?id=1563980&group=94590 Localhost CREATE USER 'MaksimDotskin'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON *.*…

Continue ReadingLOCALHOST/SQL SERVER — KASUTAJAD JA ÕIGUSED

autod

CREATE table auto( autoID int not null primary key AUTO_INCREMENT, mudel varchar(20), mark varchar(20), varv varchar(20), v_aasta int); CREATE USER 'opilaneMaksim'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT USAGE ON *.* TO…

Continue Readingautod