In the future, just paste all the errors in your post. It's rarely a good idea to not do that.

Has anyone hasd as imilar problem? How can this be resolved?

I'd say lots of people --- This can be solved by reading. I will now quote from the errors you posted

I will use the following settings for compiling and testing:
 
  cflags        (guessed) = -I/usr/local/mysql/include
  libs          (guessed) = -L/usr/local/mysql/lib -lmysqlclient -lz -lgz
  nocatchstderr (default) = 0
  ssl           (guessed) = 0
  testdb        (default) = test
  testhost      (default) =
  testpassword  (default) =
  testuser      (default) =
 
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
 

See the part in bold? You need to do that. You can also find INSTALL at http://search.cpan.org/src/JWIED/DBD-mysql-2.1026/INSTALL.html. The instructions are pretty short. Good luck.

update: Also, besides all CPAN common practices, it's always a good idea to read the README/INSTALL files before attempting to install any modules, particularly ones which require a compiler.

MJD says you can't just make shit up and expect the computer to know what you mean, retardo! I run a Win32 PPM repository for perl 5.6x+5.8x. I take requests. ** The Third rule of perl club is a statement of fact: pod is sexy.