Mysql: Encryption of passwords in tig_users table
How to ensure that the tig_users table in tigasedb (MySQL) the passwords are hashed and not the direct strings? Is there some setting or flag that goes in the init.properties file to achieve this?
Added by Wojciech Kapcia about 4 years ago
One option, that would require using SASL-PLAIN would be enabling MD5 password hashing in the database:
call TigPutDBProperty('password-encoding', <hashing>);
<hashing> can be one of the following: @'MD5-PASSWORD'@, @'MD5-USERID-PASSWORD'@, @'MD5-USERNAME-PASSWORD'@.
An alternative would be using SCRAM.