Secure authentication error when connecting to SQL server from RMySQL

Question

I am trying to connect to a MySQL server on a VM from RMySQL, here are the commands that I executed

c<-dbConnect(MySQL(), user="root", password="passw0rd", dbname="leopard", host="one-1368") 

The following error is displayed

 RS-DBI driver: (Failed to connect to database: Error: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) 

I am using MySQL client 5.6 on my system, and the VM shows that it is running 5.5. I think this may be a problem on the server version.

Any help would be greatly appreciated. Thank you.

Answer 1

You may have the old my.cnf configuration on your local machine. You can override the secure_auth client parameter in my.cnf or in the specific configuration file that you pass dbConnect ()

dbConnect(MySQL(), default.file="your-file.cnf"

The configuration information is here:

https://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth

As an aside, you really shouldn't use password hashing in 4.1 style :)