Could not mount database when using sqldf in r

Question

I uploaded the csv file to my R, and when I tried to use sqldf to select some column, it always went to

Error in .local(drv, ...) : 
  Failed to connect to database: Error: Access denied for user 
  'User'@'localhost' (using password: NO)
Error in !dbPreExists : invalid argument type

I do not know how to fix this.

Here is my script:

library("RMySQL")
library(sqldf)
acs<-read.csv("getdata_data_ss06pid.csv",head = T)
sqldf("select pwgtp1 from acs where AGEP < 50")

Answer 1

It seems that you do not need to load the library RMySQLwhen using sqldf, since you already read the data in memory, which seems like a problem here:

library(RMySQL)
library(sqldf)
sqldf("select * from df limit 6")

Error in .local (drv, ...): Could not connect to database: Error: Could not connect to local MySQL server through socket '/tmp/mysql.sock' (2) Error in! DbPreExists: invalid argument type

, RMySQL , sqldf :

detach("package:RMySQL", unload=TRUE)
sqldf("select * from df limit 6")
#   time  type
# 1    1 type1
# 2    2 type1
# 3    3 type2
# 4    4 type1
# 5    5 type2
# 6    6 type1

Answer 2

DL;

, RMySql, sqldf SQLite sqldf:

options(sqldf.driver = "SQLite")
sqldf("select * from df limit 6")

, sqldf , DB :

, "dbDriver" , set then sqldf , RPostgreSQL, RMySQL RH2 , , . , "SQLite". _ = NULL, .

RMySql , sqldf MySQL test. RMySql , . @GaborGrothendieck, sqldf, DB , ..

sqldf("select * from df limit 6", drv="SQLite")

drv="SQLite", SQLite:

options(sqldf.driver = "SQLite")