ubuntu user from mysql database code example

Example 1: see mysql users ubuntu

SELECT User, Host FROM mysql.user;

Example 2: create user database mysql command ubuntu

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';