Error in .local(drv, …) : Failed to connect to database: Error: Can't connect to MySQL server on...
up vote
0
down vote
favorite
I am getting erro in .local(drv,...).
I have no idea how to fix this issue.
Can anyone help me out why showing such a error and how to fix this error?
code:
library(RMySQL)
mydb = dbConnect(MySQL(), user='XXXXXXX',
password='XXXXXXXX', dbname='XXXXXXXX',
host='##.143.13.XXX', port=XXXX)
Thank you.
r rmysql
asked Nov 19 at 13:11
Sanky Ach
206
add a comment |
up vote
0
down vote
favorite
I am getting erro in .local(drv,...).
I have no idea how to fix this issue.
Can anyone help me out why showing such a error and how to fix this error?
code:
library(RMySQL)
mydb = dbConnect(MySQL(), user='XXXXXXX',
password='XXXXXXXX', dbname='XXXXXXXX',
host='##.143.13.XXX', port=XXXX)
Thank you.
r rmysql
asked Nov 19 at 13:11
Sanky Ach
206
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am getting erro in .local(drv,...).
I have no idea how to fix this issue.
Can anyone help me out why showing such a error and how to fix this error?
code:
library(RMySQL)
mydb = dbConnect(MySQL(), user='XXXXXXX',
password='XXXXXXXX', dbname='XXXXXXXX',
host='##.143.13.XXX', port=XXXX)
Thank you.
r rmysql
asked Nov 19 at 13:11
Sanky Ach
206
I am getting erro in .local(drv,...).
I have no idea how to fix this issue.
Can anyone help me out why showing such a error and how to fix this error?
code:
library(RMySQL)
mydb = dbConnect(MySQL(), user='XXXXXXX',
password='XXXXXXXX', dbname='XXXXXXXX',
host='##.143.13.XXX', port=XXXX)
Thank you.
r rmysql
r rmysql
asked Nov 19 at 13:11
Sanky Ach
206
asked Nov 19 at 13:11
Sanky Ach
206
edited Nov 19 at 13:21
asked Nov 19 at 13:11
Sanky Ach
206
asked Nov 19 at 13:11
Sanky Ach
206
asked Nov 19 at 13:11
Sanky Ach
206
206
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Try using DBI and pool packages from R.
library(DBI)
library(pool)
pool <- dbPool(drv = RMySQL::MySQL(), dbname = "dbName", host = "localhost", username = "root", password = "psw", port = 3306, unix.sock = "/var/run/mysqld/mysqld.sock")
df <- dbGetQuery(pool, "SELECT * FROM tablename;")
Provide MySQL socket path of the machine at unix.sock(in ubuntu : mysql_config --socket)
answered Nov 20 at 4:44
msr_003
3671315
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Try using DBI and pool packages from R.
library(DBI)
library(pool)
pool <- dbPool(drv = RMySQL::MySQL(), dbname = "dbName", host = "localhost", username = "root", password = "psw", port = 3306, unix.sock = "/var/run/mysqld/mysqld.sock")
df <- dbGetQuery(pool, "SELECT * FROM tablename;")
Provide MySQL socket path of the machine at unix.sock(in ubuntu : mysql_config --socket)
answered Nov 20 at 4:44
msr_003
3671315
add a comment |
up vote
0
down vote
Try using DBI and pool packages from R.
library(DBI)
library(pool)
pool <- dbPool(drv = RMySQL::MySQL(), dbname = "dbName", host = "localhost", username = "root", password = "psw", port = 3306, unix.sock = "/var/run/mysqld/mysqld.sock")
df <- dbGetQuery(pool, "SELECT * FROM tablename;")
Provide MySQL socket path of the machine at unix.sock(in ubuntu : mysql_config --socket)
answered Nov 20 at 4:44
msr_003
3671315
add a comment |
up vote
0
down vote
up vote
0
down vote
Try using DBI and pool packages from R.
library(DBI)
library(pool)
pool <- dbPool(drv = RMySQL::MySQL(), dbname = "dbName", host = "localhost", username = "root", password = "psw", port = 3306, unix.sock = "/var/run/mysqld/mysqld.sock")
df <- dbGetQuery(pool, "SELECT * FROM tablename;")
Provide MySQL socket path of the machine at unix.sock(in ubuntu : mysql_config --socket)
answered Nov 20 at 4:44
msr_003
3671315
Try using DBI and pool packages from R.
library(DBI)
library(pool)
pool <- dbPool(drv = RMySQL::MySQL(), dbname = "dbName", host = "localhost", username = "root", password = "psw", port = 3306, unix.sock = "/var/run/mysqld/mysqld.sock")
df <- dbGetQuery(pool, "SELECT * FROM tablename;")
Provide MySQL socket path of the machine at unix.sock(in ubuntu : mysql_config --socket)
answered Nov 20 at 4:44
msr_003
3671315
answered Nov 20 at 4:44
msr_003
3671315
answered Nov 20 at 4:44
msr_003
3671315
answered Nov 20 at 4:44
msr_003
3671315
3671315
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53375393%2ferror-in-localdrv-failed-to-connect-to-database-error-cant-connect%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
