We need dplyr for this: library(dplyr) First, use the anon user to log into the SQL server (user = “anon”, pass = “”, ip = “128.199.203.208”, port = 3306): sql = src_mysql(“population_freqs”, host = “128.199.203.208”, user = “anon”, port = 3306) Select the 1000 genomes phase 3 table: sql_1kg = tbl(sql, “1000genomes_phase3”) #look at the […]