How to connect R to MySql

Question

Hi Team,

I am new to R. I have configured MySQL server in the Local system. How can I connect R to the MySQL server?

Answer 1

Hi@akhtar,

Once the package is installed, you can create a connection object in R to connect to the database. It takes the username, password, database name, and hostname as input.

mysqlconnection = dbConnect(MySQL(), user = 'root', password = '', dbname = 'sakila', host = 'localhost')
# List the tables available in this database.
dbListTables(mysqlconnection)