%vsi uporabniki
SELECT User, Host, Password FROM mysql.user;

%kdo sem jaz
SELECT CURRENT_USER();

SELECT USER();

https://dev.mysql.com/doc/refman/5.7/en/adding-users.html

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

CREATE USER 'student123'@'pb' IDENTIFIED BY 'geslo123';
GRANT ALL ON sandbox.* TO 'student123'@'pb';
#GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
#ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;


bejek pip