Install CPAN

yum -y install cpan
cpan App::cpanminus

Install C compiler

[root@yogya ~]# yum -y install cpp

Install MySql developer libraries

[root@yogya mysql-database-stuff]# yum -y install msql-devel

Install DBI and YAML

[root@yogya mysql-database-stuff]# cpan DBI
[root@yogya mysql-database-stuff]# cpan
cpan[2]> install YAML

Om de een of andere reden lukt installeren van DBD::mysql niet met CPAN.
Dus MySql installation from source. Download source distro.

http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql/INSTALL.pod#Manual_installation

[root@yogya ~]# wget http://cpan.metacpan.org/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.028.tar.gz
[root@yogya ~]# gunzip DBD-mysql-4.028.tar.gz
[root@yogya ~]# tar xvf DBD-mysql-4.028.tar 
[root@yogya ~]# cd DBD-mysql-4.028

Maak even de test database en zet een password voor de root user

mysql> create database test;
mysql> use mysql;
mysql> update user set password = password ( 's3kr1t' ) where user = 'root'

Make sure options match, dus kijk even wat je in moet vullen om de Makefile te bouwen met.

[root@yogya DBD-mysql-4.028]# perl Makefile.PL --help

Usage: perl Makefile.PL [options]

Possible options are:
  --cflags=       Use  for running the C compiler; defaults

                         to the value of "mysql_config --cflags" or a guessed

                         value

  --libs=          Use  for running the linker; defaults

                         to the value of "mysql_config --libs" or a gussed

                         value

  --force-embedded       Build version of driver supporting mysqlEmb

  --embedded=      Use these libs when building the embedded version of

                         DBD (with --force-embedded). Defaults to the value of

                         "mysql_config --embedded".

  --testdb=          Use the database  for running the test suite;

                         defaults to test

  --testuser=      Use the username  for running the test suite;

                         defaults to no username

  --testpassword=   Use the password  for running the test suite;

                         defaults to no password

  --testhost=      Use  as a database server for running the

                         test suite; defaults to localhost.

  --testport=      Use  as the port number of the database;

                         by default the port number is choosen from the

                         mysqlclient library

  --mysql_config=  Specify  for mysql_config script

  --with-mysql=    Specify  for the root of the MySQL installation.

  --nocatchstderr        Supress using the "myld" script that redirects

                         STDERR while running the linker.

  --nofoundrows          Change the behavior of $sth->rows() so that it

  			 returns the number of rows physically modified

			 instead of the rows matched

  --ps-protocol          Toggle the use of driver emulated prepared statements

                         prepare, requires MySQL server >= 4.1.3 for

                         server side prepared statements, off by default

  --bind-type-guessing   Toggle the use of driver attribute mysql_bind_type_guessing

                         This feature makes it so driver-emulated prepared statements

                         try to "guess" if a value being bound is numeric, in which

                         case, quotes will not be put around the value.

  --ssl			         Enable SSL support

  --help                 Print this message and exit
All options may be configured on the command line. If they are

not present on the command line, then mysql_config is called (if

it can be found):
  mysql_config --cflags

  mysql_config --libs

  mysql_config --embedded

  mysql_config --testdb
and so on. See DBD::mysql::INSTALL for details.
Finish installation. In dit geval hoef je alleen het password op te geven.


[root@yogya DBD-mysql-4.028]# perl Makefile.PL --testpassword=s3kr1t

[root@yogya DBD-mysql-4.028]# make

[root@yogya DBD-mysql-4.028]# make test

[root@yogya DBD-mysql-4.028]# make install