At the moment, the driver supports only authentication with a SHA1 hashed password, also known as “mysql_native_password”.
See also: https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html.
The original code was published by Marc Christenson, Sisu Devices, on the NI Forums Example Program Code Exchange and was then improved by Steve Watts and Mark Yedinak.
You can find detailed information about the protocol in the MySQL Online Documentation.