Tag Archives: MySQL

Setting up R to connect to MySQL/MariaDB

If you need R to connect to MySQL or getting the error below from your script:

Error in dyn.load(file, DLLpath = DLLpath, ...) : 
  unable to load shared object '/usr/local/lib/R/site-library/RMySQL/libs/RMySQL.so':
  libmysqlclient.so.18: cannot open shared object file: No such file or directory

Then it can be solved by these commands

R -i

You will get a question about choosing a mirror to get the package from, just choose the one nearest to you.

Adminer – MariaDB/MySQL/PostGreSQL/SQLite Database management in a single file

If you wan’t easy external access to a MariaDB/MySQL/PostGreSQL/SQLite and some other known databases that consist of a single php file that is easy to setup on any webserver with PHP then Adminer is a great and handy little solution to install.

Here is a small screenshot of the system, it allows the most basic SQL features as creating a database, handle table schema, insert, update, create an query a database.

Adminer is also faster and tidier than phpMyAdmin that would be the closest similar management system.

Read more and download Adminer here