[Linux]ubuntu Installation of Rmysql package

Http://downloads.mysql.com/docs/connector-odbc-en.pdf

http://blog.csdn.net/ixidof/article/details/5958904

Http://askubuntu.com/questions/446483/how-to-investigate-mariadb-unixodbc-issue-further

Http://stackoverflow.com/questions/27030590/is-there-compatible-odbc-driver-with-mariadb-10-on-linux

http://blog.csdn.net/ixidof/article/details/5958904

http://blog.csdn.net/htyy521/article/details/1834962

Toss for a long time, the final success is a bit strange, tidy up the notes, not sure to accurately restore.

The first problem is that Ubuntu is under the R Command Line window:

Install.packages (' Rmysql ')

Error. The error message is probably libmariadb.so.2:shared object Cann ' t not???

I guess it was the lack of a driver's problem. Because the database used in the environment is MARIADB, it prompts libmariadb.so.2 to have a problem.

The MARIADB on the machine was installed by a former engineer, and the mariadb Lib was all placed under the/USR/LOCAL/LIB/MARIADB path.

Universal database drivers seem to be placed under/usr/local/lib. But at the time, I thought, as long as the configuration, note that the path should be mariadb, not affect. So it's not too much of a thing.

After I looked up some information on the Internet, I decided that it was an ODBC problem, chose to study the installation of ODBC, and started this 3-day pit-daddy tour.

Finally in the desperate situation, I will mariadb in the Lib file moved out, the result bang! Enter r cmd and the install is successful.

I'm not sure if the final success has any credit for the environment I was in front of. If I had directly moved libmariadb and other files to the Lib path, I do not know whether the success.

As for the specific process, and so on, I will later put the relevant content of ODBC and then write it out.

[Linux]ubuntu Installation of Rmysql package