cannot install RMySQL "there is no package called ‘RMySQL’

[kaileena]

cannot install RMySQL on databricks. i tried:

install.packages("RMySQL")

i got the 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) ================================================== 
<a lot of error code, cannot exceed post lenght in databricks forum>
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) ================================================== 
Error in library(RMySQL) : there is no package called ‘RMySQL’
Error in library(RMySQL): there is no package called ‘RMySQL’

[Anonymous]

@miru miro​ :

It seems like the error message is indicating that there is an issue accessing the package repository at https://cloud.r-project.org/src/contrib/. This could be due to various reasons, such as network connectivity issues or the repository being down.

You can try specifying a different repository by using the repos argument in the

install.packages function. For example, you can try using the following command to install RMySQL from the CRAN repository:

install.packages("RMySQL", repos = "http://cran.us.r-project.org")

This should download and install the package from a different repository. If this still does not work, you may need to investigate further into the network connectivity issues or try installing the package manually.

[Anonymous]

Hi @miru miro​ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!