SQL 12.11.2021

CREATE USER 'marcin'@'localhost|%'
CREATE USER 'alicja'@'localhost' IDENTIFIED BY 'selret';
set password for 'alicja' = PASSWORD('nowe');
set password for 'alicja'@'localhost' = PASSWORD('nowe');
RENAME USER 'alicja'@'localhost' to 'aliicja'@'localhost';
DROP USER 'marcin'@'localhost';
SHOW GRANTS FOR 'aliicja'@'localhost';
grant select, insert on 3bklo.pracownicy TO 'aliicja'@'localhost';
grant all on *.* to 'aliicja'@'localhost';
revoke all on *.* from 'aliicja'@'localhost';