i tried to install RMySQL on databricks like this:

install.packages("RMySQL")

i got this error:

Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/shinydashboard_0.7.2.tar.gz' Content type 'application/octet-stream' length 239254 bytes (233 KB) ================================================== downloaded 233 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' also installing the dependencies ‘lazyeval’, ‘crosstalk’ trying URL 'https://cran.microsoft.com/src/contrib/lazyeval_0.2.2.tar.gz' Content type 'application/octet-stream' length 83482 bytes (81 KB) ================================================== downloaded 81 KB trying URL 'https://cran.microsoft.com/src/contrib/crosstalk_1.2.0.tar.gz' Content type 'application/octet-stream' length 296495 bytes (289 KB) ================================================== downloaded 289 KB trying URL 'https://cran.microsoft.com/src/contrib/DT_0.27.tar.gz' Content type 'application/octet-stream' length 1498173 bytes (1.4 MB) ================================================== downloaded 1.4 MB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/shinythemes_1.2.0.tar.gz' Content type 'application/octet-stream' length 972144 bytes (949 KB) ================================================== downloaded 949 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/reshape_0.8.9.tar.gz' Content type 'application/octet-stream' length 41843 bytes (40 KB) ================================================== downloaded 40 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' also installing the dependency ‘reactR’ trying URL 'https://cran.microsoft.com/src/contrib/reactR_0.4.4.tar.gz' Content type 'application/octet-stream' length 714589 bytes (697 KB) ================================================== downloaded 697 KB trying URL 'https://cran.microsoft.com/src/contrib/reactable_0.4.3.tar.gz' Content type 'application/octet-stream' length 982963 bytes (959 KB) ================================================== downloaded 959 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' also installing the dependencies ‘XML’, ‘TTR’, ‘rlist’, ‘zoo’, ‘xts’, ‘quantmod’, ‘igraph’, ‘rjson’ trying URL 'https://cran.microsoft.com/src/contrib/XML_3.99-0.13.tar.gz' Content type 'application/octet-stream' length 970757 bytes (948 KB) ================================================== downloaded 948 KB trying URL 'https://cran.microsoft.com/src/contrib/TTR_0.24.3.tar.gz' Content type 'application/octet-stream' length 317338 bytes (309 KB) ================================================== downloaded 309 KB trying URL 'https://cran.microsoft.com/src/contrib/rlist_0.4.6.2.tar.gz' Content type 'application/octet-stream' length 72870 bytes (71 KB) ================================================== downloaded 71 KB trying URL 'https://cran.microsoft.com/src/contrib/zoo_1.8-11.tar.gz' Content type 'application/octet-stream' length 781934 bytes (763 KB) ================================================== downloaded 763 KB trying URL 'https://cran.microsoft.com/src/contrib/xts_0.13.0.tar.gz' Content type 'application/octet-stream' length 453032 bytes (442 KB) ================================================== downloaded 442 KB trying URL 'https://cran.microsoft.com/src/contrib/quantmod_0.4.20.tar.gz' Content type 'application/octet-stream' length 156640 bytes (152 KB) ================================================== downloaded 152 KB trying URL 'https://cran.microsoft.com/src/contrib/igraph_1.4.1.tar.gz' Content type 'application/octet-stream' length 2910158 bytes (2.8 MB) ================================================== downloaded 2.8 MB trying URL 'https://cran.microsoft.com/src/contrib/rjson_0.2.21.tar.gz' Content type 'application/octet-stream' length 116509 bytes (113 KB) ================================================== downloaded 113 KB trying URL 'https://cran.microsoft.com/src/contrib/highcharter_0.9.4.tar.gz' Content type 'application/octet-stream' length 1073325 bytes (1.0 MB) ================================================== downloaded 1.0 MB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/priceR_0.1.67.tar.gz' Content type 'application/octet-stream' length 74790 bytes (73 KB) ================================================== downloaded 73 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/pool_1.0.1.tar.gz' Content type 'application/octet-stream' length 39744 bytes (38 KB) ================================================== downloaded 38 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/RODBC_1.3-20.tar.gz' Content type 'application/octet-stream' length 929898 bytes (908 KB) ================================================== downloaded 908 KB The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Installing package into ‘/local_disk0/.ephemeral_nfs/envs/rEnv-c677bc4c-e6a3-40df-a5ab-bfd5d277e0c0’ (as ‘lib’ is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib: cannot open URL 'https://cloud.r-project.org/src/contrib/PACKAGES' trying URL 'https://cran.microsoft.com/src/contrib/RMySQL_0.10.25.tar.gz' Content type 'application/octet-stream' length 53316 bytes (52 KB) ================================================== downloaded 52 KB Warning in utils::install.packages(pkgs, ...) : installation of package ‘RMySQL’ had non-zero exit status The downloaded source packages are in ‘/tmp/Rtmp4ZFosL/downloaded_packages’ Using libcurl 7.68.0 with GnuTLS/3.6.13 Attaching package: ‘shinydashboard’ The following object is masked from ‘package:graphics’: box Attaching package: ‘DT’ The following objects are masked from ‘package:shiny’: dataTableOutput, renderDataTable Attaching package: ‘dplyr’
<more code>
 The following object is masked from ‘package:shiny’: getDefaultReactiveDomain Attaching package: ‘scales’ The following object is masked from ‘package:purrr’: discard Attaching package: ‘dbplyr’ The following objects are masked from ‘package:dplyr’: ident, sql
Error in library(RMySQL) : there is no package called ‘RMySQL’
Error in library(RMySQL): there is no package called ‘RMySQL’