01.R설치 실행 http://cran. r-project.org/mirrors.html0-Cloud https://cloud.r-project.org/Automatic redirection to servers worldwide, currently sponsored by Rstudio Algeria https://cran.usthb.dz/University of Science and Technology Houari Boumediene Argentina http://mirror.fcaglp.unlp.edu.ar/CRAN/Universidad Nacional de La Plata Australia http://cr… cran.r-project.orgR실행 결과
02.IDE, RStudio 인스톨, 실행 https://www.rstudio.com/products/rstudio/download/ #download R Studioisaset of integrated to help youbemore productive with R.It include saconsole, syntax-highlightingeditorthatsupports direct codexecution, and avariety ofrobution, www.rstudio.com/products/rstudio/download/senotethattheseareoldversions.Newreleaseswillhaverecentbugfixesandfeatures!TodownloadthelatestreleaseofMySQLCommunityServer,pleasevisitMySQLDownloads.ProductVersion:OperatingSystem:Windows(x86,64-bit),ZIPArchiveJul1,2…downloads.mysql.comhttps://dev.mysql.com/downloads/installer/General Availability (GA) Releases Archives MySQL Installer 8.0.27 Looking for previous GA versions? Select Operating System: Windows (x86,32-bit), MSI Installer 8.0.27 2.4M Download (mysql-installer-web-codity) | Sownload (mysql-installer-web-coad
2) MySQL > DataBase 작성, Table 작성, Data 입력
04.R Tools(Using Rtools4on Windosw)설치, 실행(RMySQL을 사용하기 위해 반드시 설치할 필요는 없음)https://cran.r-project.org/bin/windows/Rtools/InstallingRtoolsNotethatRtoolsisonlyneedbuildRpackageswithC/C++/Fortrancodefromsource.Bydefault,RforWindowsinstallstheprecompiled”binarypackages”fromCRAN,forwhichyoudoneedRtools.Toustools, download the installer from CRAN: On Windows 64-bit: rtools40v2-x86…cran.r-project.orghttps://cran.r-project.org/web/packages / RMySQL / index.html Legacy ‘DBI’ interface to ‘MySQL’ / ‘MariaDB’ based on old code ported from S-PLUS. Amodern’ MySQL’ cli old code praded from is Traster’s S-Prm S-PLUS.Rm on the S-PLUS.Rment S-PLUS.Rma skrivern’SQL
- RMySQL 사용법 http://cra n.r-project.org/web/packages/RMySQL/RMySQL.pdf
- ※ caching_sha2_password Error 발생해결방법 Library pathis’/mingw64/lib/mariadb/plugin/caching_sha2_password.dl’
- → MySQL에서 userpassword를 변경 mysql> alteruser’root’@’localhost’identified with mysql_native_password by’test’; Query OK, 0rowsaffected(0.01sec)
2) R에서 MySQL 연동 (Db연결, 조회, Db연결 끊김)
※ 참고자료 서적 : R을 이용한 데이터 처리 & 분석 실무
https://blog.naver.com/flddifsqra08/222538762378MySQL 연동 데이터가 MySQL과 같은 데이터베이스에 저장되어 있거나 데이터베이스 기능을 활용한… blog.naver.com