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)