Mysql users

Show logged user
SELECT USER(),CURRENT_USER();

Show all mysql database users
SELECT User FROM mysql.user;

Show user with pass and host
select user, password, host from mysql.user;

Update user password
ALTER USER 'mysql.user'@'localhost' IDENTIFIED BY 'New-Password-Here';

Show users privileges
SHOW GRANTS FOR 'user'@'localhost';

Remove user privileges
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on `database`.* FROM 'user'@'localhost';