MySQL аутентификация по паролю

set password = password("XH4VmT3_jt");

Проверка:

MariaDB [(none)]> SELECT user,authentication_string,plugin,host FROM mysql.user;
+------+-------------------------------------------+-----------------------+-----------+
| user | authentication_string                     | plugin                | host      |
+------+-------------------------------------------+-----------------------+-----------+
| root | *F4CCF44B3A1BD98C48CA63AE04E8FE40AE67E96E | mysql_native_password | localhost |
+------+-------------------------------------------+-----------------------+-----------+
2 rows in set (0.000 sec)

https://mariadb.com/kb/en/authentication-from-mariadb-104/