ERROR when install RMySQL

Question

[kwang140630]

Hello, when I install RMySQL, I keep getting the following error:

connection.c: In function 'RS_MySQL_moreResultSets':
connection.c:224:3: error: unknown type name 'my_bool'; did you mean '_Bool'?
   my_bool           tmp;
   ^~~~~~~
   _Bool
make: *** [connection.o] Error 1
ERROR: compilation failed for package ‘RMySQL’
* removing ‘/root/miniconda2/lib/R/library/RMySQL’
Installation failed: Command failed (1)

Would any one know why? Any help and advice is greatly appreciated!

Kai

[h.mon]

In the future, please format your post to make it more readable, using the code sample and block quote buttons. I did some formatting to you this time.

Answer 1

[h.mon]

What is the command you are using to install RMySQL? Did you see there is a conda r-rmysql package (in fact, two) and you can install it with conda install -c r r-rmysql or conda install -c conda-forge r-rmysql.

[kwang140630]

Thanks.

I used conda install rmysql. It didn't work. Your code conda install -c r r-rmysql solved my problem.

Kai