Error installing RMySQL (MySQL 5.5.37 in Ubuntu 14.04 )

Every time I try installing RMySQL I get the following error: ``` Installing package into ‘/home/ehsan/R/x86_64-pc-linux-gnu-library/3.0’ (as ‘lib’ is unspecified) * installing *source* package ‘RMySQL’ ... ** package ‘RMySQL’ successfully unpacked and MD5 sums checked checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking how to run the C preprocessor... gcc -E checking for compress in -lz... yes checking for getopt_long in -lc... yes checking for mysql_init in -lmysqlclient... yes checking for egrep... grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking mysql.h usability... no checking mysql.h presence... no checking for mysql.h... no configure: creating ./config.status config.status: creating src/Makevars ** libs gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mysql/mysql.h -fpic -O3 -pipe -g -c RS-DBI.c -o RS-DBI.o cc1: warning: /usr/include/mysql/mysql.h: not a directory [enabled by default] gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mysql/mysql.h -fpic -O3 -pipe -g -c RS-MySQL.c -o RS-MySQL.o cc1: warning: /usr/include/mysql/mysql.h: not a directory [enabled by default] In file included from RS-MySQL.c:22:0: RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory #include <mysql.h> ^ compilation terminated. make: *** [RS-MySQL.o] Error 1 ERROR: compilation failed for package ‘RMySQL’ * removing ‘/home/ehsan/R/x86_64-pc-linux-gnu-library/3.0/RMySQL’ The downloaded source packages are in ‘/tmp/RtmpTRRPqg/downloaded_packages’ Warning message: In install.packages("RMySQL") : installation of package ‘RMySQL’ had non-zero exit status** ``` Seemingly, it cannot find mysql.h and I searched and changed the path to export PKG_CPPFLAGS="-I/usr/R/include/mysql/mysql.h" but it was not successful. There're many people who have had the same issue but non of their solutions (if existed) worked for me. I'd appreciate any comment or help. #Update: Issue Resolved# The following command seemed to solve the issue: sudo apt-get install r-cran-rmysql