Failed to connect to database: Error: Plugin mysql_clear_password could not be loaded

Question

I'm trying to connect to MySQL Workbench using RMySQL:

con <- dbConnect(dbDriver("MySQL"), host="hostName", port = number, user = "user", password = "password", dbname="dbname")

and I got an error:

Error in .local(drv, ...) : Failed to connect to database: Error: Plugin mysql_clear_password could not be loaded: The specified module could not be found.

I couldn't find anything about that error in RMySQL and I don't know how to solve that problem. Anyone could help?

Is this error coming from your code or from the MySQL server itself? — tadman
– tadman, Commented Aug 23, 2016 at 7:55
Probably from code. I mean I can see it in terminal in R Studio and I don't have any other information about that except for that what I wrote above... :( — Natalia
– Natalia, Commented Aug 23, 2016 at 8:07
@Natalia Please check the ODBC driver is installed on your computer. May be you could check with local database first before making a connection to remote database. Also please check the following link here — Shiva Prakash
– Shiva Prakash, Commented Aug 23, 2016 at 11:09

Shayan Shafiq · Accepted Answer · 2021-01-05 09:55:31Z

3

Set system environment variable LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN = Y:

edited Jan 5, 2021 at 9:55

Shayan Shafiq

1,4775 gold badges21 silver badges25 bronze badges

answered Nov 8, 2020 at 18:19

Michele Delle Donne

2112 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Salem Baira Over a year ago

You are a true legend!

Collectives™ on Stack Overflow

Failed to connect to database: Error: Plugin mysql_clear_password could not be loaded

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related