I´ve installed xampp 8.2.0-0 on a mac book pro 14 inches, chip Apple M1 pro, OS Monterey. I've tried to connect RStudio version 2022.07.1 to Mariadb database that is part of xamp 8.2.0-0.
In Rstudio console I previously installed package RMariaDB. I've follow the script
drv <- dbDriver("MySQL")
con <- dbConnect(drv, username="root",
password="",
dbname ="db_name",
host="localhost")
However, I got the following error message
"Error: Failed to connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
How can it be solved ?