mysql security related sqls

show all users in mysql
select host, user, password from mysql.user;

grant all privilege to root from localhost
grant all on * to 'root'@'localhost';

grant all privilege to user_a from all hosts
grand all on * to 'user_a'@'%';