Create mariadb user, password from cli

Create mariadb user, password from cli

While developing a CMS we don't have phpmyadmin, plesk or cpanel rather a simple cli. So to create a quick DB with a user who has all privileges to the DB and a password to the user just give these commands. I think this method works for mysql too.

$ mysql -u adminusername -p
Enter password:
mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON databasename.* TO "username"@"hostname" IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> EXIT
Bye
$