blocks|key|1268212|text|没有可用于RMySQL包的windows二进制文件。这意味着你必须从源代码安装这个包，并自己构建它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1268213|在CRAN+RMySql页面上，您会注意到没有可用的二进制文件，其中有一个指向Pre-compiled+binary+packages+for+R-2.14.x+for+Windows的链接|1268214|在此页面中：|1268215|Packages+related+to+many+database+system+must+be+linked+to+the+exact+
version+of+the+database+system+the+user+has+installed,+hence+it+does+
not+make+sense+to+provide+binaries+for+packages
++++RMySQL,+ROracle,+ROracleUI,
although+it+is+possible+to+install+such+packages+from+sources+by
++++install.packages('packagename',+type='source')
after+reading+the+manual+'R+Installation+and+Administration'.|code-block|syntax|javascript|1268216|因此，请阅读手册，特别是R+Installation+and+Administration，安装RTools，然后使用：|1268217|install.packages('RMySQL',+type='source')|1268218|entityMap|0|LINK|mutability|MUTABLE|url|http://cran.r-project.org/web/packages/RMySQL/index.html|1|http://cran.r-project.org/bin/windows/contrib/r-release/ReadMe|2|http://cran.r-project.org/doc/manuals/R-admin.html^0|5|6|0|1|B|0|13|1H|1|0|0|0|C|X|2|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|17|8|@]|D|@$9|18|A|19|1|1A]|$9|1B|A|1C|1|1D]]|E|$]]|$1|H|3|I|5|6|7|1E|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|1F|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1G|8|@]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|Q|3|R|5|L|7|1K|8|@]|D|@]|E|$M|N]]|$1|S|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]|10|$5|V|W|X|E|$Y|11]]|12|$5|V|W|X|E|$Y|13]]]]

There is not a windows binary available for the package <code>RMySQL</code>. This means you will have to install this package from source and build it yourself.

At the <a href="http://cran.r-project.org/web/packages/RMySQL/index.html" rel="nofollow" title="CRAN RMySql">CRAN RMySql</a> page you will notice there is no binary available, with a link to <a href="http://cran.r-project.org/bin/windows/contrib/r-release/ReadMe" rel="nofollow" title="Readme">Pre-compiled binary packages for R-2.14.x for Windows</a>

From this page:

<pre><code>Packages related to many database system must be linked to the exact 
version of the database system the user has installed, hence it does 
not make sense to provide binaries for packages
 RMySQL, ROracle, ROracleUI,
although it is possible to install such packages from sources by
 install.packages('packagename', type='source')
after reading the manual 'R Installation and Administration'.
</code></pre>

So, read the manuals, in particular <a href="http://cran.r-project.org/doc/manuals/R-admin.html" rel="nofollow" title="R installation">R Installation and Administration</a>, install RTools, and then use:

<pre><code>install.packages('RMySQL', type='source')
</code></pre>

blocks|key|866121|text|安装Rtools后，从RMySQL+CRAN+page从Package+source:链接获取源代码，以确保您拥有最新版本。然后阅读软件包附带的INSTALL文件中的信息(或者在前面提到的CRAN页面上的Installation:链接中找到相同的信息)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|866122|大多数人的主要问题是遵循互联网上与旧版本的RMySQL有关的过时信息，而不是使用软件包本身的说明。|866123|entityMap|0|LINK|mutability|MUTABLE|url|http://cran.r-project.org/bin/windows/Rtools/|1|http://cran.r-project.org/web/packages/RMySQL/index.html^0|S|F|20|7|2U|D|2|6|0|B|G|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@$9|Y|A|Z|1|10]|$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]]]

After installing <a href="http://cran.r-project.org/bin/windows/Rtools/" rel="nofollow">Rtools</a>, from the <a href="http://cran.r-project.org/web/packages/RMySQL/index.html" rel="nofollow">RMySQL CRAN page</a> grab the source from the <code>Package source:</code> link to ensure that you have the latest version. Then read the information in the <code>INSTALL</code> file that comes with the package (or find the same info at the <code>Installation:</code> link on the aforementioned CRAN page).

The main problem that most people have is following outdated information on the internet that pertains to older versions of RMySQL rather than using the instructions that come with the package itself.

blocks|key|1268289|text|在花了10个小时后，我遵循了阿恩的指示和威廉的评论：http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/，它像魔术一样工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1268290|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/^0|Q|1U|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

After spending 10Hours,I followed Arne's instructions and Willem's comment from here:
<a href="http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/" rel="nofollow">http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/</a> and it worked like magic.

blocks|key|1268333|text|我在R中安装+RMySQL包时遇到了一些困难，今年有两次是这样。我还没用过呢。为了帮助我绕过已知的其他问题，我遵循了在这两篇文章中找到的步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1268334|1268335|Installing+RMySQL+under+Windows|unordered-list-item|offset|length|1268336|Vanderbilt+University+RMySQL+page|1268337|1268338|首先，您需要下载、安装并配置MySQL以与Windows一起工作。接下来，您必须创建或编辑一个名为Renviron.site的文件，并将变量MYSQL_HOME添加到您的默认环境中，以及其他一些微妙的调整，这些调整可能适用于其他人，但不适用于我。|style|CODE|1268339|似乎不建议在Windows上运行RMySQL；您还可以使用其他包来让R与MySQL一起工作。我已经查看了R博客，R+Studio支持和R帮助邮件列表，寻找解决这个问题的方法。|1268340|尽管它们是有用的资源，但不能保证故障排除步骤对每个人都有效。您可以尝试按照它们来安装RMySQL包，如果它们正常工作，您应该能够将该包用于R。|1268341|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/|1|http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL^0|0|0|0|V|0|0|0|X|1|0|0|1Y|A|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|H|3|I|5|E|7|18|8|@]|9|@$F|19|G|1A|1|1B]]|A|$]]|$1|J|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1D|8|@$F|1E|G|1F|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

I experienced some difficulty with installing RMySQL package in R, twice this year. I haven't used it, yet. To help me in getting around the known additional problems, I followed the steps I found in these two articles:

<ul>
<li><a href="http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/" rel="nofollow">Installing RMySQL under Windows</a></li>
<li><a href="http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL" rel="nofollow">Vanderbilt University RMySQL page</a></li>
</ul>

First you need to download, install and configure MySQL to work with Windows. Next, you will have to create or edit a file called Renviron.site, and add the variable <code>MYSQL_HOME</code> to your default environment, and other tricky tweaks that may have worked for other people, but have not worked for me.

It appears that running RMySQL on Windows is not advised; there are other packages that you can use to get R to work with MySQL. I've been checking out R bloggers, R Studio Support and the R Help Mailing List, for ways to get around the problem. 

Although they're useful resources, there is no guarantee that the troubleshooting steps will work for everyone. You can try following them to install RMySQL package, and if they work you should be able to use the package with R.

I tried to use RMySQL package but i get this error doing:

<pre><code>install.packages('RMySQL')

Warning in install.packages :
 package ‘RMySQL’ is not available (for R version 2.14.2)
</code></pre>

What can I do to use MySQL with R?

Thank you!

How to use RMySQL in Windows?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我尝试使用RMySQL包，但在执行以下操作时出现以下错误：install.packages('RMySQL')Warning in install.packages :  package ‘RMySQL’ is not available (for R version 2.14.2)要将MySQL与R一起使用，我可以做些什么？谢谢!

问如何在Windows中使用RMySQL？
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Windows中使用RMySQL？EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Windows中使用RMySQL？
EN