##Contributed by - Vasudeva Rao Create user in mysql: mysql> CREATE USER 'test_user'@'%' IDENTIFIED BY 'test_user'; Query OK, 0 rows affected (0.02 sec) mysql> GRANT ALL ON *.* TO 'user'@'localhost'; Query OK, 0 rows affected (0.01 sec)

View create user statements: MariaDB [(none)]> SHOW CREATE USER 'test_user'@'localhost'; MariaDB [(none)]> SHOW CREATE USER 'test_user'@'%'; Create user with password expire:

MariaDB [(none)]> CREATE USER 'test_user2'@'localhost' IDENTIFIED BY 'test_user' PASSWORD EXPIRE; Query OK, 0 rows affected (0.004 sec) Drop user: MariaDB [(none)]> drop user 'test_user'@'localhost'; Query OK, 0 rows affected (0.009 sec)