I am running version 5.0.21.
I have a mariadb setup with with users and passwords.
I am able to connect to the database and it seems to be running my query.
I am providing the hash and the salt for pbkdf2.
Pseudorandom Function is sha512
Iteration Count is 100000
Derived Key Length is 64
The log file isn’t very helpful.
I am assuming the has should be in hex and the salt as a string. Right now the salt is encoded as base64, which I am not sure is a problem or not.
The reason I am assuming this is based on the documentation provided here, which has an insert statement showing the hash in hex and the salt as a string: Password Authentication Using MySQL | EMQX 5.0 Documentation
The output of my query when ran manually looks like this:
password_hash - hex
04F38FE9A708EB361DD6F7EF0AACF86275B0FB9F6A6DA8530D9C6078CEB267623A135585B6B11AD2E928DDB0EDBC9AB5D7A873A3FE35F6417BDCB719FD2B4E13
salt (base64 encoded)
6SQKt7zB5SluVknVJ+9+Wg==