Benchmark MySQL installation requiring default-auth=mysql_native_password

[smitty-codes]

Hi, we have a MySQL installation (I think that is old) that requires the mysql native password argument - example from mysql command line below:
shell> mysql --default-auth=mysql_native_password ...

Reference link: https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html

How can we pass this connection parameter thru the Hammerdb config XML files or thru the GUI?

For more context, in the MySQL Connector/C++ version, the argument is "defaultAuth=mysql_native_password"

[sm-shaw]

This is the default connection in HammerDB so default_authentication_plugin=mysql_native_password is set in the my.cnf.
There currently isn't a direct option to change the authentication plugin. (It has not been investigated to see if it is possible to pass it through the password option).
The interface used is here https://github.com/xdobry/mysqltcl/blob/master/generic/mysqltcl.c and uses the C interface.
The current options are:
[-user xxx] [-db mysql] [-port 3306] [-host localhost] [-socket sock] [-password pass] [-encoding encoding] [-ssl boolean] [-compress boolean] [-odbc boolean] [-noschema boolean] [-reconnect boolean]
If someone wants to update this interface then HammerDB could include this option in future.
The same interface has now been adapted to support MariaDB as well https://github.com/Jiang-Hua/mariatcl which will be in HammerDB v4.2.

[smitty-codes]

Thanks for the feedback. Unfortunately haven’t worked in C for many years so likely will not be able to fix myself right now.

We ended up abandoning HammerDB and went with dbbench https://github.com/memsql/dbbench as a workaround.

[sm-shaw]

Will leave this open as someone may wish to enable authentication beyond the default mysql_native_password. For now this has not been an issue. So will be tagged as low priority.

A best practice guide to contributing to HammerDB is here: https://www.hammerdb.com/blog/uncategorized/interacting-with-open-source-for-hammerdb-code-and-documentation/
This primer on database benchmarking is also useful to introduce the concepts of parallelism and concurrency and the differences between them - such as where co-routines should and shouldn't be used: https://www.hammerdb.com/blog/uncategorized/what-programming-languages-does-hammerdb-use-and-why-does-it-matter/.