Unable to install RMySQL on macOS 10.13.6

[alecshaw]

I am currently trying to install RMySQL as it is a dependency for the mdsr package. The following is the error message I receive.

clang -I"/usr/local/Cellar/r/3.5.1/lib/R/include" -DNDEBUG -I/usr/local/Cellar/mysql/8.0.12/include/mysql   -I/usr/local/opt/gettext/include -I/usr/local/opt/readline/include -I/usr/local/include   -fPIC  -g -O2  -c connection.c -o connection.o
connection.c:224:3: error: use of undeclared identifier 'my_bool'
  my_bool           tmp;
  ^
connection.c:229:3: error: use of undeclared identifier 'tmp'
  tmp = mysql_more_results(my_connection);
  ^
connection.c:230:24: error: use of undeclared identifier 'tmp'
  return ScalarLogical(tmp);
                       ^

I have tried a few different Stack Overflow threads, but they haven't solved the issue. Any help would be much appreciated.

Edit: It looks like pull request #223 would sort this out.

macOS 10.13.6
R 3.5.1
MySQL 8.0.12 Homebrew

[bouzidnm]

Any updates? I'm having the same problem.

[jpryda]

bump to this

[skodman]

Same with Oracle linux 7.5 and it is really annoying. Somehow i have this running at work on virtual machine under Oracle Virtual box. I can't make it work on my spare laptop where i have ol_75 installed.
It seems to be related to the my_bool being removed from MySQL 8. It would be really great to have this sorted out

[ekoepplin]

Any updates? I'm having the same problem.

[skodman]

After wasting significant amount of time i decided to roll back to MySQLversion 5.7. All works fine under this version on Oracle Linux. Also, i should clarify that i was able to install and use RMySQL on windows box and connect to MySQL8 on remote db server running on linux. So the issue is related to Linux and Mac OS.

[ankane]

fwiw, you can do:

git clone https://github.com/r-dbi/RMySQL.git
cd RMySQL
git pull origin 70116a3ec0ba1683502aa04e0542489f9c85c87c

And run

devtools:install()

To use #223 (for some reason, devtools::install_github("r-dbi/RMySQL#223") doesn't work)

[jeroen]

This fix is on cran now.