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
You will get a question about choosing a mirror to get the package from, just choose the one nearest to you.
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