1、出现时的场景:
(1)已经配置ODBC数据源
(2)在Rstudio中的代码
library(RODBC)
require(RODBC)
con <- odbcConnect("RMysql", uid="root", pwd="passWord");
但是还是出现错误了!!!!
Warning messages:
1: In RODBC::odbcDriverConnect("DSN=RMysql;UID=root;PWD=passWord") :
[RODBC] ERROR: state HY000, code 1045, message [MySQL][ODBC 8.0(a) Driver]Access denied for user 'root'@'localhost' (using password: YES)
2: In RODBC::odbcDriverConnect("DSN=RMysql;UID=root;PWD=passWord") :
ODBC connection failed
自己找不到原因,求助各位大神,这是怎么回事?怎么解决!xie'xie