title: New Error installing RMySQL on SUSE Tumbleweed
body: <p>I'm having a 'new' problem installing RMySQL on SUSE Tumbleweed 20210618.  I have previously had RMySQL working, but between projects, RMySQL mysteriously disappeared from R.</p>
  <p>Now, when I run 'install.packages' - it is incorrectly reading my mysql_config parameters (as shown below).  As is evident from the mysql_config info (also shown below), the two don't match up.</p>
  <p>Is there a way to 'correct' the way that the PKG_CFLAGS and PKG_LIBS are set - so that they point to the proper locations?  Or, is there some other problem that causes this to perpetuate?</p>
  <p>Thanks...</p>
  <p>This is my 'install.packages' run:</p>
  <pre><code>Installing package into ‘/home/craig/R/x86_64-suse-linux-gnu-library/4.1’
  (as ‘lib’ is unspecified)
  trying URL 'https://cran.rstudio.com/src/contrib/RMySQL_0.10.21.tar.gz'
  Content type 'application/x-gzip' length 53075 bytes (51 KB)
  ==================================================
  downloaded 51 KB
  
  * installing *source* package ‘RMySQL’ ...
  ** package ‘RMySQL’ successfully unpacked and MD5 sums checked
  ** using staged installation
  Found mysql_config cflags and libs!
  Using PKG_CFLAGS=-I/usr//usr/include/mysql -I/usr//usr/include/mysql/mysql
  Using PKG_LIBS=-L/usr//usr/lib64/ -lmariadb
  -----------------------------[ ANTICONF ]-----------------------------
  Configure could not find suitable mysql/mariadb client library. Try installing:
   * deb: libmariadbclient-dev | libmariadb-client-lgpl-dev (Debian, Ubuntu)
   * rpm: mariadb-connector-c-devel | mariadb-devel | mysql-devel (Fedora, CentOS, RHEL)
   * csw: mysql56_dev (Solaris)
   * brew: mariadb-connector-c (OSX)
  If you already have a mysql client library installed, verify that either
  mariadb_config or mysql_config is on your PATH. If these are unavailable
  you can also set INCLUDE_DIR and LIB_DIR manually via:
  R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=...'
  --------------------------[ ERROR MESSAGE ]----------------------------
  &lt;stdin&gt;:1:10: fatal error: mysql.h: No such file or directory
  compilation terminated.
  -----------------------------------------------------------------------
  ERROR: configuration failed for package ‘RMySQL’
  * removing ‘/home/craig/R/x86_64-suse-linux-gnu-library/4.1/RMySQL’
  Warning in install.packages :
    installation of package ‘RMySQL’ had non-zero exit status
  
  The downloaded source packages are in
      ‘/tmp/RtmpvBirrZ/downloaded_packages’
  </code></pre>
  <p>and my info from mysql_config is:</p>
  <pre><code>Copyright 2011-2020 MariaDB Corporation AB
  Get compiler flags for using the MariaDB Connector/C.
  Usage: mysql_config [OPTIONS]
  Compiler: GNU 11.1.1
    --cflags        [-I//usr/include/mysql -I//usr/include/mysql/mysql]
    --include       [-I//usr/include/mysql -I//usr/include/mysql/mysql]
    --libs          [-L//usr/lib64/ -lmariadb]
    --libs_r        [-L//usr/lib64/ -lmariadb]
    --libs_sys      [-lz -ldl -lm -lpthread -lssl -lcrypto]
    --version       [10.5.5]
    --cc_version    [3.1.12]
    --socket        [/run/mysql/mysql.sock]
    --port          [3306]
    --plugindir     [-L/usr/lib64 -lmariadbprivate -lz -ldl -lm -lpthread -lssl -lcrypto]
    --tlsinfo       [//usr/lib64/mysql/plugin/]
    --variable=OpenSSL 1.1.1k
        pkgincludedir  [//usr/include/mysql]
        pkglibdir      [//usr/lib64]
        pkgplugindir   [//usr/lib64/mysql/plugin/]
    --privatelibs   [VAR  VAR is one of:]
  </code></pre>
  <p>Note that PKG_CFLAGS from the install.packages command is reading the config file incorrectly (converting it to -I/usr//usr/include... instead of the -I//usr/include..., for example).</p>