Alon, I remember having the same problem than you, but I am using Ubuntu

I solved that by installing  libmysqlclient16-dev   using  "sudo apt-get
install libdbd-mysql libmysqlclient16-dev"

I don't know what command equivalet you have in Suse

Radhouane

2011/4/6 alon.benari <alon.benari@gmail.com>

> Hello All,
>
> I have a technical difficulty installing RMySQL. I am running openSUSE11.1
> and R 2.12
> I have installed MySQL from the website.
> and following installation , as root
> This is the part where trouble begin,
> ......
> checking mysql.h usability... no
> checking mysql.h presence... no
> checking for mysql.h... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking /usr/local/include/mysql/mysql.h usability... no
> checking /usr/local/include/mysql/mysql.h presence... no
> checking for /usr/local/include/mysql/mysql.h... no
> checking /usr/include/mysql/mysql.h usability... no
> checking /usr/include/mysql/mysql.h presence... no
> checking for /usr/include/mysql/mysql.h... no
> checking /usr/local/mysql/include/mysql/mysql.h usability... no
> checking /usr/local/mysql/include/mysql/mysql.h presence... no
> checking for /usr/local/mysql/include/mysql/mysql.h... no
> checking /opt/include/mysql/mysql.h usability... no
> checking /opt/include/mysql/mysql.h presence... no
> checking for /opt/include/mysql/mysql.h... no
> checking /include/mysql/mysql.h usability... no
> checking /include/mysql/mysql.h presence... no
> checking for /include/mysql/mysql.h... no
>
> Configuration error:
>  could not find the MySQL installation include and/or library
>  directories.  Manually specify the location of the MySQL
>  libraries and the header files and re-run R CMD INSTALL.
>
> INSTRUCTIONS:
>
> 1. Define and export the 2 shell variables PKG_CPPFLAGS and
>   PKG_LIBS to include the directory for header files (*.h)
>   and libraries, for example (using Bourne shell syntax):
>
>      export PKG_CPPFLAGS="-I"
>      export PKG_LIBS="-L -lmysqlclient"
>
>   Re-run the R INSTALL command:
>
>      R CMD INSTALL RMySQL_.tar.gz
>
> 2. Alternatively, you may pass the configure arguments
>      --with-mysql-dir= (distribution directory)
>   or
>      --with-mysql-inc= (where MySQL header files reside)
>      --with-mysql-lib= (where MySQL libraries reside)
>   in the call to R INSTALL --configure-args='...'
>
>   R CMD INSTALL --configure-args='--with-mysql-dir=DIR' RMySQL_.tar.gz
>
> ERROR: configuration failed for package ‘RMySQL’
> * removing ‘/root/R/i686-pc-linux-gnu-library/2.12/RMySQL’
>
> Any ideas how to proceed from here? I am quite a newbie in LINUX
> How do I find the mysql.h ?
> using find / -name mysql.h but nothing there?
> Did I use it right?
> Any other ideas? How do I set this right?
>
> Thank you
>
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Cannot-install-pakcage-RMySQL-tp3431025p3431025.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
**

	[[alternative HTML version deleted]]

