MySQL on Windows

perleager has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: MySQL on Windows by Putzfrau (Beadle) on Apr 25, 2002 at 12:59 UTC
Yes you can, It's easiest to install DBI if you've got ActiveState Perl and have PPM at your disposal. Just activate PPM from the perl/bin directory (usually c:\perl\bin). `>PPM` then install DBI `>Install DBI` the rest of the install is automatic This is how i got DBI installed on our school's win2k test server it's not much advice and I might be wrong, but I hope it helps you out "when a new client is created, we have to kill all the children..." --Sams Teach yourself Perl 5	[reply] [d/l] [select]
Re: MySQL on Windows by AidanLee (Chaplain) on Apr 25, 2002 at 12:56 UTC
I have done this without any issues. As long as you've got normal perl cgi scripts running ok on your web server, adding DBI to the mix is a non-issue.	[reply]
Re: MySQL on Windows by drewbie (Chaplain) on Apr 25, 2002 at 13:43 UTC
Yes, DBI is the right solution. Yes, DBI is available for Win32. As Putzfrau mentioned, PPM and ActiveState is your friend on Windows. And there are many sources for PPM versions of popular modules. Randy Kobes even has a PPM of mod_perl for windows, which works quite well.	[reply]
Re: MySQL on Windows by Sifmole (Chaplain) on Apr 25, 2002 at 12:49 UTC
I have used the DBI libraries on windows to access a MySQL database. I was not running the Win2K server, but Apache instead; But I would believe the DBI would still work. Your best bet is to just try it by creating a quick and dirty script to find out.	[reply]
Re: MySQL on Windows by ckohl1 (Hermit) on Apr 25, 2002 at 15:29 UTC
Getting to a MySQL server on a Windows 2000 machine is not a problem. If your scripts are running on a Win32 box, you have a couple of options for reaching the database. You can use Win32::ODBC package to access the database, or use DBI with either the ODBC or MySQL interface. If your scripts are running on a non-Win32 platform, then you probably will not be able to use the Win32::ODBC package (never say never). PS: The ppm install directive for the MySQL interface to DBI is 'install DBD-Mysql'. Chris	[reply]