Hi, Let me answer one question
The process you are following seems a bit long. You can use mysql Package in R and directly access Mysql on the server. Server connect using SSH.
So an easy job for me.
Relevant Skills and Experience
Database administration, OLAP Cube, Unix, Cloud networking, I short all it takes to be a data engineer
Proposed Milestones
$20 USD - On partial 50 percent completing