$1.$ Connect to the following mysql database.

user$=$'admin',

password$=$'dataprogramming',

db$\_$name$=\text{'}$db$\text{'},$

host$=$'dataprogrammingdb.crlxiaocbkou.us$-$west$-1.$rds$.$amazonaws.com'

$2.$ Create a database with name yourFirstName$\_$yourLastName

$3.$ Upload the mpg dataset.

$4.$ Filter rows where manufacturer is $\text{'}\text{'}$dodge$"$ and create a data$-$frame.

$5.$ Select following columns: "manufacturer", "model", "displ", "year", $"$cyl$",$ and "trans", and create a data$-$frame.

Hint: Use Filter and Selection using SQL$.$RDownload Filter and Selection using SQL$.$R

Submit a R file with your assignment code.