Create mysql user, give database permission and show all users

Create Mysql user :

CREATE USER ‘testuser’@’localhost’ IDENTIFIED BY ‘test123test!’;

Grant All permissions :

grant all privileges on mydb.* to myuser@localhost identified by ‘mypasswd’;

Show all mysql users :

SELECT * FROM mysql.user;