create user mariadb code example

Example 1: create user mariadb

CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';

Example 2: mariadb alter user host

UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='username';
FLUSH PRIVILEGES;