-- Uzivatele


select * from user;
select Host, user, … from user;

-- opravnění
show grants;
SHOW GRANTS FOR 'root'@'localhost';
SHOW GRANTS FOR CURRENT_USER;


-- uživatel tvorba
CREATE USER 'uco'@'localhost' IDENTIFIED BY 'heslo';

insert into user (user, host, password) values ('franta','192.168.0.100','atnarf');


-- Práva
GRANT práva [sloupce] 
ON položka_kde 
TO uživatel [IDENTIFIED BY 'heslo' ] 
[REQUIRE volby_ssl] 
[WITH [GRANT OPTION | volby_omezení] ]


GRANT ALL ON uco.* TO 'uco'@'localhost'
GRANT SELECT, INSERT, DELETE ON database.* TO 'uco'@'localhost';


REVOKE ALL PRIVILEGES FROM 'uco…'@'localhost';


SET PASSWORD FOR 'uco…'@'localhost' = PASSWORD('tajne_heslo');


-- smazání uzivatele
DROP USER ‘uživatel’@‘localhost’;