php 5.5.1：configure: error: Cannot find MySQL header files under

Hello friends,

Well I am trying to compile php 5.5.1 from tar.gz.. I am getting an error while configuring, which I don't seem to understand well.

I am configuring it using below;
./configure --prefix=/usr/local/php5 --with-config-file-path=/usr/local/php5 --with-mysql=/usr/include/mysql/ --with-apxs2=/usr/local/apache2/bin/apxs --with-jpeg-dir=/usr/local/modules/jpeg/ --with-freetype-dir=/usr/lib --with-zlib-dir=/lib/ --with-png-dir=/usr/local/modules/libpng/ --with-libxml-dir=/usr/local/modules/libxml2 --with-gd=/usr/local/modules/gd2/ --with-mysqli=/usr/bin/mysql_config

The error I am getting is:

Configuring extensions
checking size of long... (cached) 4
checking size of int... (cached) 4
checking for int32_t... yes
checking for uint32_t... yes
checking for sys/types.h... (cached) yes
checking for inttypes.h... (cached) yes
checking for stdint.h... (cached) yes
checking for string.h... (cached) yes
checking for stdlib.h... (cached) yes
checking for strtoll... yes
checking for atoll... yes
checking for strftime... (cached) yes
checking which regex library to use... php
checking whether to enable LIBXML support... yes
checking libxml2 install dir... /usr/local/modules/libxml2
checking for xml2-config path... /usr/local/modules/libxml2/bin/xml2-config
checking whether libxml build works... yes
checking for OpenSSL support... no
checking for Kerberos support... no
checking for PCRE library to use... bundled
checking whether to enable the SQLite3 extension... yes
checking bundled sqlite3 library... yes
checking for ZLIB support... no
checking if the location of ZLIB install directory is defined... /lib/
checking for zlib version >= 1.2.0.4... 1.2.3
checking for gzgets in -lz... yes
checking whether to enable bc style precision math functions... no
checking for BZip2 support... no
checking whether to enable calendar conversion support... no
checking whether to enable ctype functions... yes
checking for cURL support... no
checking for QDBM support... no
checking for GDBM support... no
checking for NDBM support... no
checking for TCADB support... no
checking for Berkeley DB4 support... no
checking for Berkeley DB3 support... no
checking for Berkeley DB2 support... no
checking for DB1 support... no
checking for DBM support... no
checking for CDB support... no
checking for INI File support... no
checking for FlatFile support... no
checking whether to enable DBA interface... no
checking whether to enable DOM support... yes
checking for xml2-config path... (cached) /usr/local/modules/libxml2/bin/xml2-config
checking whether libxml build works... (cached) yes
checking for ENCHANT support... no
checking whether to enable EXIF (metadata from images) support... no
checking for fileinfo support... yes
checking for utimes... yes
checking for strndup... yes
checking whether to enable input filter support... yes
checking pcre install prefix... no
checking whether to enable FTP support... no
checking OpenSSL dir for FTP... no
checking for GD support... yes
checking for the location of libvpx... no
checking for the location of libjpeg... /usr/local/modules/jpeg/
checking for the location of libpng... /usr/local/modules/libpng/
checking for the location of libXpm... no
checking for FreeType 2... /usr/lib
checking for T1lib support... no
checking whether to enable truetype string function in GD... no
checking whether to enable JIS-mapped Japanese font support in GD... no
If configure fails try --with-vpx-dir=<DIR>
checking for jpeg_read_header in -ljpeg... yes
checking for png_write_image in -lpng... yes
If configure fails try --with-xpm-dir=<DIR>
checking for FT_New_Face in -lfreetype... yes
If configure fails try --with-vpx-dir=<DIR>
checking for jpeg_read_header in -ljpeg... (cached) yes
checking for png_write_image in -lpng... (cached) yes
If configure fails try --with-xpm-dir=<DIR>
checking for FT_New_Face in -lfreetype... (cached) yes
checking for gdSetErrorMethod in -lgd... yes
checking for gdImageCreateFromPng in -lgd... yes
checking for gdImageCreateFromWebp in -lgd... no
checking for gdImageCreateFromJpeg in -lgd... yes
checking for gdImageCreateFromXpm in -lgd... yes
checking for gdImageStringFT in -lgd... yes
checking for gdImageCreate in -lgd... yes
checking for GNU gettext support... no
checking for GNU MP support... no
checking for mhash support... no
checking whether to enable hash support... yes
checking whether byte ordering is bigendian... (cached) no
checking size of short... 2
checking size of int... (cached) 4
checking size of long... (cached) 4
checking size of long long... (cached) 8
checking for iconv support... yes
checking for iconv... yes
checking if iconv is glibc's... yes
checking if iconv supports errno... yes
checking if your cpp allows macro usage in include lines... yes
checking for IMAP support... no
checking for IMAP Kerberos support... no
checking for IMAP SSL support... no
checking for InterBase support... no
checking whether to enable internationalization support... no
checking whether to enable JavaScript Object Serialization support... yes
checking for ANSI C header files... (cached) yes
checking for LDAP support... no
checking for LDAP Cyrus SASL support... no
checking whether to enable multibyte string support... no
checking whether to enable multibyte regex support... yes
checking whether to check multibyte regex backtrack... yes
checking for external libmbfl... no
checking for external oniguruma... no
checking for mcrypt support... no
checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
configure: error: Cannot find MySQL header files under /usr/include/mysql/.
Note that the MySQL client library is not bundled anymore!

I have following mysql packages installed
MySQL-client-advanced-5.6.12-1.el6.i686
MySQL-devel-advanced-5.6.12-1.el6.i686
MySQL-server-advanced-5.6.12-1.el6.i686

Any help will be greatly appreciated,thanks

--with-mysql=/usr/include/mysql/

/usr/include/mysql/ is not where mysql is installed
it would be /usr .In the default location .

and why this ?

-with-jpeg-dir=/usr/local/modules/jpeg/

jpeg 6 should be in /usr/lib/libjpeg.so.62.0.0
it is installed by default
unless you ALSO have a second and different version also installed and in possible conflict with the rpm installed by default

the same goes for this

--with-png-dir=/usr/local/modules/libpng/

libpng is a default installed rpm
and is installed in /usr/lib/libpng.so.3.49.0

autotools should take care of almost all of the settings
all that should be needed is

/configure --prefix=/usr/local/php5 --with-config-file-path=/usr/local/php5 --with-mysql --with-apxs2  --with-gd --with-mysqli

but if you only run this

/configure --prefix=/usr/local/php5

the auto testing will very likely set everything
read the configure output and or the "configure.log"


for a list of what IS tested for AND the default setting have a read through the "--help" output for THAT configure file

in the php source folder run

./configure --help

THanks john.I got it.