mysql set password

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