1、初次使用
con <- dbConnect(MySQL(), user = 'root', password = '144230', dbname = 'test', host='localhost')
错误于mysqlNewConnection(drv, ...) :
RS-DBI driver: (Failed to connect to database: Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
)
无语:又报错
2、网上说需要先安装 mysql-workbench 试试能否正常连接
当然先安装 MySQL,这个我以前写过,接下来安装 mysql-workbench,mysql-workbench 需要先安装 mysql-share,下载的文件如下
[root@localhost mysql]# ls
MySQL-shared-compat-5.6.16-1.linux_glibc2.5.i386.rpm
mysql-workbench-community-6.0.9-1.el6.i686.rpm
//然后安装:
[root@localhost mysql]# rmp -ivh MySQL-shared-compat-5.6.16-1.linux_glibc2.5.i386.rpm
[root@localhost mysql]# rmp -ivh mysql-workbench-community-6.0.9-1.el6.i686.rpm
搞定,可以正常连接:
6、可是我的 RMySQL 还是连不上。怎么办? 查看基本信息
> dbConnect(m, user = "root", password = "144230", dbname = "test", host="localhost.localdomain")
<MySQLConnection:(9246,0)>
> m <- MySQL()
> m
<MySQLDriver:(9246)>
> dbConnect(m, user = "root", password = "144230", dbname = "test")
错误于mysqlNewConnection(drv, ...) :
RS-DBI driver: (Failed to connect to database: Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
)
> Sys.info()
sysname release
"Linux" "2.6.32-358.el6.i686"
version nodename
"#1 SMP Thu Feb 21 21:50:49 UTC 2013" "localhost.localdomain"
machine login
"i686" "clebeg"
user effective_user
"clebeg" "clebeg"
哦,原来它识别不了默认的 host
接下来用下面语句链接:
> dbConnect(m, user = "root", password = "144230", dbname = "test", host="localhost.localdomain")
<MySQLConnection:(9246,1)>
> conn <- dbConnect(m, user = "root", password = "144230", dbname = "test", host="localhost.localdomain")
> table.names = dbListTables(con)
> table.names
[1] "t_user"