MariaDB [(none)]> SET PASSWORD FOR 'username'@'localhost' = PASSWORD('xxxxxxx'); Query OK, 0 rows affected (0.04 sec)