title: Error installing RMySQL (MySQL 5.5.37 in Ubuntu 14.04 )
body: <p>Every time I try installing RMySQL I get the following error:</p>
  
  <pre><code>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 &lt;mysql.h&gt;
                     ^
  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**
  </code></pre>
  
  <p>Seemingly, it cannot find mysql.h and I searched and changed the path to</p>
  
  <blockquote>
    <p>export PKG_CPPFLAGS="-I/usr/R/include/mysql/mysql.h" </p>
  </blockquote>
  
  <p>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.</p>
  
  <p><s>#Update: Issue Resolved#</p>
  
  <p>The following command seemed to solve the issue:</p>
  
  <blockquote>
    <p>sudo apt-get install r-cran-rmysql</s></p>
  </blockquote>