MariaDB [(none)]> CREATE USER 'testuser'@'localhost' identified by '1234';

Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> ALTER USER 'testuser'@'localhost' identified by '2345';

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SET PASSWORD FOR 'testuser'@'localhost' = PASSWORD('23456');

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT version();

+---------------------+

| version()           |

+---------------------+

| 10.2.19-MariaDB-log |

+---------------------+

1 row in set (0.00 sec)

# at 386

#181116 16:04:52 server id 1  end_log_pos 504 CRC32 0x86ae998a  Query   thread_id=9     exec_time=0     error_code=0

SET TIMESTAMP=1542402292/*!*/;

SET @@session.pseudo_thread_id=9/*!*/;

SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/;

SET @@session.sql_mode=1411383296/*!*/;

SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;

/*!\C utf8 *//*!*/;

SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;

SET @@session.lc_time_names=0/*!*/;

SET @@session.collation_database=DEFAULT/*!*/;

CREATE USER 'testuser'@'localhost' identified by '1234'

/*!*/;

# at 504

#181116 16:06:00 server id 1  end_log_pos 546 CRC32 0x9f2ab113  GTID 0-1-2055772 ddl

/*!100001 SET @@session.gtid_seq_no=2055772*//*!*/;

# at 546

#181116 16:06:00 server id 1  end_log_pos 692 CRC32 0x89e90b6e  Query   thread_id=9     exec_time=0     error_code=0

SET TIMESTAMP=1542402360/*!*/;

SET PASSWORD FOR 'testuser'@'localhost'='*1BF5B468E9090C8DBE711DF031C68FF05D3F3BEC'

/*!*/;