01.R설치 실행 htt p://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/ #downloadRStudioisasetofintegrated to helpyoubemore productive with R. Itincludesaconsole, syntax-highlightingeditorthatsupports directcodeexecution, andavariety of robust to helporting, viewinghistory, debuggingyourworkspace.www.rstudio.com 03.MySQL 설치, 실행 http://downloads.mysql.com/archives/community/Pleasenotethatseareoldversions.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.272.4M Download(mysql-installer-web-community-8.0.27.0.msi) MD5 : 9766651e52a597f0350de8e80486cdac | Signature Windows(x86,32-bit) . .dev.mysql.com1) 윈도우 64,win10 환경변수 설정 MYSQL_HOME
2) MySQL > DataBase 작성, Table 작성, Data입력
04. RTools(Using Rtools 4on Windosw) 설치, 실행(RMySQL을 사용하기 위해 반드시 설치할 필요는 없습니다)https://cran.r-project.org/bin/windows/Rtools/InstallingRtoolsNotethatRtoolsisonlyneedbuildRpackageswithC/C++/Fortrancodefromsource.Bydefault、RforWindowsinstallstheprecompiled”binarypackages”fromCRAN、forwhyoudoneedRtoneedRtools.TouseedRtols, 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’clientbasedon’Rcpp’isavailable from the’RMariaDB’package.cran.r-project.org05.RMySQL 설치, 실행(RTOS)
- 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.dll’
- → MySQL에서 userpassword 변경 mysql> alteruser’root’@’localhost’identification withmysql_native_passwordby’test’; QueryOK, 0rowsaffected (0.01sec)
2) R에서 MySQL 연동(Db접속, 조회, Db접속절단)
※ 참고 자료 서적 : R을 이용한 데이터 처리 & 분석 실무
https://blog.naver.com/flddifsqra08/222538762378MySQL 연동 데이터가 MySQL과 동일한 데이터베이스에 저장되어 있거나 데이터베이스 기능을 활용한 … blog.naver.com