Now the error message is that it cannot find "mysql.h"--a file that exists nowhere on the machine

That file and the rest of the mysql library ships with Strawberry Perl 5.32.1.
The 'mysql.h' file is in Strawberry's c/include/mysql50716 folder, the static library ('libmysql.a') is in Strawberry's c/lib folder and the shared library ('libmysql__.dll) is in Strawberry's c/bin folder.

If you're using Strawberry Perl, I recommend building against that mysql library, rather than the one that xampp provided.
After all, the mysql library that ships with the Strawberry Perl distro is the one against which Strawberry's DBD::mysql was built.

OTOH, if you're using XAMPP's perl, then you should build against the mysql library that they provided.

HTH.
(I haven't read this thread thoroughly, and I don't do databases. I concede that this post might therefore be of no help at all.)

Update:
By the way, XAMPP's version of Perl is: 5.32.1, said to be "built for MSWin32-x64-multi-thread"

If you want to check that this version of perl is compatible with Strawberry Perl 5.32.1, just run perl -V:archname using your Strawberry Perl 5.32.1.
If it reports 'MSWin32-x64-multi-thread', then they're compatible. Else, they are incompatible.

Cheers,
Rob

In reply to Re^2: Perl XAMPP DB Connect issue (Windows/Strawberry?) by syphilis
in thread Perl XAMPP DB Connect issue (Windows/Strawberry?) by Polyglot

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.