Documentation Home
MySQL 9.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 9.0 Reference Manual  / ...  / Installing MySQL  / Perl Installation Notes  /  Installing Perl on Unix

2.10.1 Installing Perl on Unix

MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). Most installation methods install the necessary files. If you install MySQL from RPM files on Linux, be sure to install the developer RPM as well. The client programs are in the client RPM, but client programming support is in the developer RPM.

The files you need for Perl support can be obtained from the CPAN (Comprehensive Perl Archive Network) athttp://search.cpan.org.

The easiest way to install Perl modules on Unix is to use theCPAN module. For example:

$> perl -MCPAN -e shellcpan> install DBIcpan> install DBD::mysql

TheDBD::mysql installation runs a number of tests. These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, andODBC on Windows. The default password is“no password.”) If you cannot connect to the server with those values (for example, if your account has a password), the tests fail. You can useforce install DBD::mysql to ignore the failed tests.

DBI requires theData::Dumper module. It may be installed; if not, you should install it before installingDBI.

It is also possible to download the module distributions in the form of compressedtar archives and build the modules manually. For example, to unpack and build a DBI distribution, use a procedure such as this:

  1. Unpack the distribution into the current directory:

    $> gunzip < DBI-VERSION.tar.gz | tar xvf -

    This command creates a directory namedDBI-VERSION.

  2. Change location into the top-level directory of the unpacked distribution:

    $> cd DBI-VERSION

  3. Build the distribution and compile everything:

    $> perl Makefile.PL$> make$> make test$> make install

Themake test command is important because it verifies that the module is working. Note that when you run that command during theDBD::mysql installation to exercise the interface code, the MySQL server must be running or the test fails.

It is a good idea to rebuild and reinstall theDBD::mysql distribution whenever you install a new release of MySQL. This ensures that the latest versions of the MySQL client libraries are installed correctly.

If you do not have access rights to install Perl modules in the system directory or if you want to install local Perl modules, the following reference may be useful:http://learn.perl.org/faq/perlfaq8.html#How-do-I-keep-my-own-module-library-directory-