To access SQL Server from Perl on Linux, we used Easysoft ODBC drivers with Perl DBI and DBD::ODBC on Debian GNU/Linux, RedHat and Ubuntu (Edgy Eft, Feisty Fawn, Gutsy Gibbon and Hardy Heron). Easysoft ODBC drivers should work with any recent 32-bit or 64-bit Linux distribution—CentOS, Fedora, Kubuntu, Mandrake/Mandriva, OpenSUSE/SUSE, RedHat. Before installing perl module, you must install client for accessing Postgres DB. I just install server and header files: sudo apt-get install postgresql sudo apt-get install libpq-dev.
2.5.6 Installing MySQL on Linux Using Debian Packages from Oracle
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels:
Perl Dbd Mysql Rpm
The MySQL APT Repository, supporting Debian and Ubuntu platforms. For details, see Section 2.5.3, “Installing MySQL on Linux Using the MySQL APT Repository”.
The MySQL Developer Zone's Download Area. For details, see Section 2.1.3, “How to Get MySQL”. The following are some information on the Debian packages available there and the instructions for installing them:
You may also need to install the
libaiolibrary if it is not already present on your system:
Various Debian packages are provided in the MySQL Developer Zone for installing different components of MySQL. The preferred method is to use the tarball bundle, which contains the packages needed for a basic setup of MySQL. The tarball bundles have names in the format of
MVERis the MySQL version and
DVERis the Linux distribution version. The
CPUvalue indicates the processor type or family for which the package is built, as shown in the following table:
Table 2.12 MySQL Debian and Ubuntu Installation PackageCPU Identifiers
Intended Processor Type or Family
Pentium processor or better, 32 bit
64-bit x86 processor
After downloading the tarball, unpack it with the following command:
In general, install the
debpackages unpacked from the tarball with the command (see explanations below for the extra steps required for installing the server package):
There are four packages to install:
The database common files (install this package before the other ones):
The MySQL server: Mac switch between fullscreen apps bind keyboard shortcuts.
Install first the package for the database common files (see the last bullet), and then pre-configure your server installation by the following command:
You are asked to provide a password for the
rootuser for your MySQL installation. You might also be asked other questions regarding the installation.
Make sure you remember the root password you set. Users who want to set a password later can leave the password field blank in the dialogue box and just press . However, it is very important that you set the password soon using the program mysql_secure_installation, as people can gain anonymous access to your MySQL server until you have secured the database's root account with a password.
Next, install the server package with the following command:
The MySQL client:
The MySQL shared client library:
Here are where the files are installed on the system:
All configuration files (like
my.cnf) are under
All binaries, libraries, headers, etc., are under
The data directory is under
Debian Perl Dbd Mysql Install Linux Debian
Debian distributions of MySQL are also provided by other vendors. Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the instructions in this manual do not necessarily apply to installing them. The vendor's instructions should be consulted instead.