DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Problems installing DBD::mysql on Solaris 8


I need to access a mysql database using perl on Solaris 8. I installed DBI already but fail to install DBD::mysql.

I get error messages that the gcc compiler does not understand certain options:
gcc: unrecognized option `-Xa'
gcc: language arch=v8 not recognized

If I just copy the to the target directory, I get error messages that the driver cannot be located in


I was in the same situation. After unpacking DBD-mysql-3.0006.tar I ran

perl Makefile.PL

Then when running make, those error messages showed up.
I looked at the options for gcc and found that I should remove them. I also found that the option for the include files (search path -I) specified a folder that did not exist in my system.
The original include file path was /usr/local/mysql/include/mysql but after installing the package on Solaris (all with the default values) it should have been /usr/local/mysql/include

So instead I created the makefile using:

perl Makefile.PL --cflags="-I/usr/local/mysql/include"

Then I issued a 'make', followed by 'make install', and everything worked fine.

Generated 0:00:40 on Nov 25, 2017