XAMPP localhost

1.make a user

2. Add permissions

4.deprive the user of privileges

REVOKE GRANT OPTION ON . FROM 'loja'@'localhost'

5. log in

6. we can create table

CREATE TABLE logi2(
   logiid INT PRIMARY KEY,
   kuupaev datetime,
   andmed text);

7. Check if we can not be droped

DROP TABLE logi2;

6.Check if we can modify

ALTER TABLE kasutaja 

ADD COLUMN age INT;