rmysql

Similar to ~/.netrc, the database passwords can be managed in ~/.dbrc, this article give a solution within R.

Setup MySQL connection using R in GNU linux