To install DBD-Maria-1.22 onto latest StrawberryPerl-5.40.0, I copied over the libmysql stuff from StrawberryPerl-5.38.2 (portable edition).
That is:
1) copy mysql_config.bat from SP-5.38.2/c/bin to SP-5.40.0/c/bin;
2) copy libmysql__.dll from SP-5.38.2/c/bin to SP-5.40.0/c/bin;
3) copy libmysql.a from SP-5.38.2/c/lib to SP-5.40.0/c/lib;
4) copy the mysql50716 folder from SP-5.38.2/c/include to SP-5.40.0/c/include;

Then I built and installed the module manually from downloaded source (by running perl Makefile.PL, then gmake test, then gmake install).
You could also install version 1.22 using either the cpan or cpanm utilities - but you have to direct it to grab the 1.22 source.

Version 1.23 won't build against that library because the symbol __imp___pioinfo can't be resolved.
If you can substitute in a (presumably more recent) mysql library that resolves that symbol, then you should be able to install version 1.23.

Cheers,
Rob