technocrat
unfortunately, i am getting errors. for some reason default is setting not to root but to user in workbench for mysql, i am identified as user . in there i need to switch to root each time. so I did try your instructions with both user and root. this is my error i don't understand. on separate note, thru terminal I connect w mysqlsh --uri root@localhost. I am real confused here, with the user and root issue. i install everything w defualts, i din't change from root. frustration.
but it should be root for rmysql is my long point here
con <- dbConnect(drv, username="root", password="NYY@NK33s", dbname ="RBaseball", host="localhost")
Error in .local(drv, ...) :
Failed to connect to database: Error: Plugin caching_sha2_password could not be loaded: dlopen(lib/mariadb/plugin/caching_sha2_password.so, 2): image not found
> con <- dbConnect(drv, username="user", password="NYY@NK33s", dbname ="RBaseball", host="localhost")
Error in .local(drv, ...) :
Failed to connect to database: Error: Plugin caching_sha2_password could not be loaded: dlopen(lib/mariadb/plugin/caching_sha2_password.so, 2): image not found