in reply to Help on how to compile/install module DBD::MariaDB/Mysql on Windows using Strawberry Perl

Are you trying to do local development of something that is in production, in Perl? Or writing Perl as part of your job, or just using Perl as a tool to help you do your job? Does your job require you to work in windows or just have it installed on your work system? The more that you can tell us, the better we can suggest things to help.

mysql 5.7 is not stable, it is well past end of life and no longer receiving security updates, so should be considered unsafe. You really should not use it unless you have to to mimic a production environment that is still using it.

That said, show more exactly what you did to try to install DBD::mysql and what errors resulted. Maybe an older version would work?

Not sure what role the database plays in your job; if you are using the MariaDB client, why not use the server too? Note that MySQL and MariaDB are not fully compatible anymore; each has added different features since the fork, or implemented new features in different, incompatible ways, though if you stick to things supported in MySQL 5.5, you won't see many issues.

Other alternatives: run perl under WSL 2, or a VM, or cygwin? Any of those can make building modules easier.
  • Comment on Re: Help on how to compile/install module DBD::MariaDB/Mysql on Windows using Strawberry Perl

Replies are listed 'Best First'.
Re^2: Help on how to compile/install module DBD::MariaDB/Mysql on Windows using Strawberry Perl
by gosseyn (Initiate) on Jul 22, 2025 at 20:44 UTC
    Sorry, perhaps it was not very explicit. Let me explain : I have more than one computer (including Macs, Raspberry PI...) but for historical reasons, I develop using Perl on a Windows PC. I mainly use MySQL and Perl to process databases requests, manipulating text files and converting data between two formats, for processing data between different softwares. For many years, I worked on this PC with MAMP and Active Perl, without any issue. MySQL 5.7 was very satisfying for my purpose. Everything was doing fine until I uninstalled Active Perl and installed Strawberry Perl, mainly because I had to reinstall some missing modules from CPAN.
    Due to the difficulties I had to install DBD::mysql modules, I tried MariaDB to check if it was working better, because more recent. I don't care to use MySQL or MariaDB. For me, this is the same. I don't need some particularities of the one or the second. And yes, I use a server in addition of the client. In fact, the mysql client or mariadb client is not very useful for me (but perhaps for the driver itself). I mainly use the server with my Perl scripts and with also a lot of PHPMyAdmin. But due to the emergency of this situation for me, I'm looking for other solutions that MySQL and MariaDB, which works pretty the same way, with Perl. But for years everything was very easy with the use of the mysql driver for DBI. I don't understand these sudden difficulties. I read here and elsewhere that I should downgrade the driver to an older version (v4x). Frankly, for my needs, I would be glad to use a binary distribution of the driver, like I had with Active Perl and PPM. It was working without any issue and was easy to install new modules.

    Unfortunately, I don't have much time to experiment different kind of installations, because I have already tried different things for the last 24 hours, including all yesterday's night. And now I need to go forward with my work, without spending extra time to try to "debug" the whole installation.

    I'll try to install Cygwin when I have so more time to play. Thanks for your help.
    Best.

    Sorry for the signature misplaced. I fixed it.
    Gosseyn
[reply]

In Section Seekers of Perl Wisdom