blocks|key|442812|text|关于Ubuntu/Debian和其他使用智能的发行版：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442813|sudo+apt-get+install+libmysql-ruby+libmysqlclient-dev|code-block|syntax|javascript|442814|包libmysql-ruby已被逐步淘汰，并被ruby-mysql所取代。这是我找到解决方案的地方。|offset|length|style|CODE|442815|如果由于找不到libmysql-ruby，上面的命令无法工作，那么下面的内容就足够了：|442816|sudo+apt-get+install+libmysqlclient-dev|442817|关于Red+/CentOS和其他使用yum的发行版：|442818|sudo+yum+install+mysql-devel|442819|基于自制软件的Mac操作系统|442820|brew+install+mysql|442821|entityMap|0|LINK|mutability|MUTABLE|url|https://askubuntu.com/a/641953|1|https://brew.sh/^0|0|0|1|D|N|A|11|1|0|0|7|D|0|0|0|0|2|4|1|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1A|8|@$I|1B|J|1C|K|L]|$I|1D|J|1E|K|L]]|9|@$I|1F|J|1G|1|1H]]|A|$]]|$1|M|3|N|5|6|7|1I|8|@$I|1J|J|1K|K|L]]|9|@]|A|$]]|$1|O|3|P|5|D|7|1L|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|1M|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1N|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1O|8|@]|9|@$I|1P|J|1Q|1|1R]]|A|$]]|$1|W|3|X|5|D|7|1S|8|@]|9|@]|A|$E|F]]|$1|Y|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]|16|$5|11|12|13|A|$14|17]]]]

On Ubuntu/Debian and other distributions using aptitude:

<pre><code>sudo apt-get install libmysql-ruby libmysqlclient-dev
</code></pre>

Package <code>libmysql-ruby</code> has been phased out and replaced by <code>ruby-mysql</code>. <a href="https://askubuntu.com/a/641953">This</a> is where I found the solution.

If the above command doesn't work because <code>libmysql-ruby</code> cannot be found, the following should be sufficient:

<pre><code>sudo apt-get install libmysqlclient-dev
</code></pre>

On Red Hat/CentOS and other distributions using yum:

<pre><code>sudo yum install mysql-devel
</code></pre>

On Mac OS X with <a href="https://brew.sh/" rel="noreferrer">Homebrew</a>:

<pre><code>brew install mysql
</code></pre>

blocks|key|1995635|text|我在mac上，使用自制安装开源程序。我确实需要安装mac工具才能安装自制软件，但在那之后，它就很简单了：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1995636|brew+install+mysql|code-block|syntax|javascript|1995637|安装mysql。从那以后，我就没有遇到过mysql创业板问题。|1995638|entityMap|0|LINK|mutability|MUTABLE|url|https://brew.sh/^0|9|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I'm on a mac and use <a href="https://brew.sh/" rel="noreferrer">homebrew</a> to install open source programs. I did have to install mac Dev tools in order to install homebrew, but after that it was a simple:

<pre><code>brew install mysql
</code></pre>

to install mysql. I haven't had a mysql gem problem since.

blocks|key|443498|text|MacOS+Mojave|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|443499|gem+install+mysql2+-v+'0.5.2'+--+--with-ldflags=-L/usr/local/opt/openssl/lib+--with-cppflags=-I/usr/local/opt/openssl/include|CODE|443500|entityMap^0|0|C|0|0|3H|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|N|8|@$9|O|A|P|B|H]]|D|@]|E|$]]|$1|I|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|J|$]]

For MacOS Mojave:

<code>gem install mysql2 -v '0.5.2' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include</code>

blocks|key|443537|text|Ubuntu上的(18.04)|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|443538|我能够通过运行以下命令来解决这个问题：|443539|sudo+apt-get+install+build-essential+libmysqlclient-dev
gem+install+mysql2|code-block|syntax|javascript|443540|参考文献|443541|entityMap|0|LINK|mutability|MUTABLE|url|https://forum.opennebula.org/t/solved-error-when-running-script-that-install-the-required-gems/7845^0|8|7|0|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|D|@$9|12|A|13|1|14]]|E|$]]|$1|O|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

On Ubuntu(18.04)

i was able to solve this issue by running the following:

<pre><code>sudo apt-get install build-essential libmysqlclient-dev
gem install mysql2
</code></pre>

<a href="https://forum.opennebula.org/t/solved-error-when-running-script-that-install-the-required-gems/7845" rel="noreferrer">reference</a>

blocks|key|442901|text|我有几台计算机，32位和64位处理器，它们运行在Ubuntu上，Maverick+(10.10)发行版。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442902|我也遇到了同样的问题，对我来说，sudo+apt-get+install+libmysql-ruby+libmysqlclient-dev完成了任务！|offset|length|style|CODE|442903|entityMap^0|0|G|1H|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I have several computers, 32 and 64 bits processor, they run on Ubuntu Linux, Maverick (10.10) release.
I had the same problem, and for me, the
<code>sudo apt-get install libmysql-ruby libmysqlclient-dev</code>
did the job!!!

blocks|key|1640844|text|为MacOS用户提供的另一种方式|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1640845|如果使用"brew“安装mysql：|1640846|gem+install+mysql2+-v+'x.x.x'+--+--with-mysql-config=/usr/local/Cellar/mysql/y.y.y/bin/mysql_config|code-block|syntax|javascript|1640847|x.x.x+=要安装的mysql2+gem的版本|1640848|Yy.y=安装了ls+/usr/local/Cellar/mysql的mysql版本来查找它。|CODE|1640849|entityMap^0|0|A|0|0|0|0|8|Q|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|X|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Y|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|Z|8|@$9|10|A|11|B|Q]]|D|@]|E|$]]|$1|R|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|S|$]]

Another way for MacOS users

If you used "brew" to install mysql:

<pre><code>gem install mysql2 -v 'x.x.x' -- --with-mysql-config=/usr/local/Cellar/mysql/y.y.y/bin/mysql_config
</code></pre>

x.x.x = version of the mysql2 gem you want to install 
y.y.y = the version of mysql you have installed <code>ls /usr/local/Cellar/mysql</code> to find it.

blocks|key|442779|text|你试过用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442780|+gem+install+mysql+--+--with-mysql-lib=/usr/lib/mysql/lib+|code-block|syntax|javascript|442781|要指定基本目录的位置以及完成gem安装所必需的MySQL库的路径？|442782|资料来源：Gem安装错误:生成MySQL本机扩展失败+MySQL论坛:：Ruby+:：MySQL绑定安装所需的帮助|offset|length|442783|entityMap|0|LINK|mutability|MUTABLE|url|http://www.question-defense.com/2009/03/10/mysql-gem-install-error-failed-to-build-gem-native-extension|1|http://forums.mysql.com/read.php?116,157273,157273#msg-157273^0|0|0|0|5|L|0|R|U|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$K|10|L|11|1|12]|$K|13|L|14|1|15]]|A|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]]]

Have you tried using

<pre><code> gem install mysql -- --with-mysql-lib=/usr/lib/mysql/lib 
</code></pre>

to specify the location of thebase directory as well as the path to the MySQL libraries that are necessary to complete the gem installation?

Sources:
<a href="http://www.question-defense.com/2009/03/10/mysql-gem-install-error-failed-to-build-gem-native-extension" rel="noreferrer">MySQL Gem Install ERROR: Failed to build gem native extension</a>
<a href="http://forums.mysql.com/read.php?116,157273,157273#msg-157273" rel="noreferrer">MySQL Forums :: Ruby :: Help needed with installing MySQL binding for Ruby</a>

blocks|key|1995710|text|如果您正在使用yum，请尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1995711|sudo+yum+install+mysql-devel|code-block|syntax|javascript|1995712|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are using yum try:

<pre><code>sudo yum install mysql-devel
</code></pre>

blocks|key|443021|text|有一次，这解决了我在Windows中的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|443022|subst+X:+"C:\Program+files\MySQL\MySQL+Server+5.5"+
gem+install+mysql2+-v+0.x.x+--platform=ruby+--+--with-mysql-dir=X:+--with-mysql-lib=X:\lib\opt+
subst+X:+/D|code-block|syntax|javascript|443023|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This solved my problem once in Windows:

<pre><code>subst X: "C:\Program files\MySQL\MySQL Server 5.5" 
gem install mysql2 -v 0.x.x --platform=ruby -- --with-mysql-dir=X: --with-mysql-lib=X:\lib\opt 
subst X: /D
</code></pre>

blocks|key|1640924|text|在Debian拉伸上，对我起作用的包是default-libmysqlclient-dev|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1640925|sudo+apt-get+update+&&+apt-get+install+-y+default-libmysqlclient-dev|CODE|1640926|entityMap^0|J|Q|0|0|1W|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|N|8|@$9|O|A|P|B|H]]|D|@]|E|$]]|$1|I|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|J|$]]

On Debian Stretch the package that worked for me was default-libmysqlclient-dev

<code>sudo apt-get update &amp;&amp; apt-get install -y default-libmysqlclient-dev
</code>

blocks|key|1640719|text|如果你仍然有困难的话…。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1640720|试着安装|1640721|+++sudo+apt-get+install+ruby1.9.1-dev|code-block|syntax|javascript|1640722|entityMap^0|0|C|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If you are still having trouble….

Try installing 

<pre><code> sudo apt-get install ruby1.9.1-dev
</code></pre>

blocks|key|1996101|text|就我而言，这起到了帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1996102|$+export+LDFLAGS="-L/usr/local/opt/openssl/lib"
$+export+CPPFLAGS="-I/usr/local/opt/openssl/include"|code-block|syntax|javascript|1996103|然后：|1996104|gem+install+mysql2+-v+'0.5.2'+--source+'https://rubygems.org/'+--+--with-cppflags=-I/usr/local/opt/openssl/include+--with-ldflags=-L/usr/local/opt/openssl/lib|1996105|结果：|1996106|Building+native+extensions+with:+'--with-cppflags=-I/usr/local/opt/openssl/include+--with-ldflags=-L/usr/local/opt/openssl/lib'
This+could+take+a+while...
Successfully+installed+mysql2-0.5.2
Parsing+documentation+for+mysql2-0.5.2
Installing+ri+documentation+for+mysql2-0.5.2
Done+installing+documentation+for+mysql2+after+0+seconds
1+gem+installed|1996107|见这篇文章+(警告:内有日语)。|offset|length|1996108|entityMap|0|LINK|mutability|MUTABLE|url|https://qiita.com/HrsUed/items/ca2e0aee6a2402571cf6^0|0|0|0|0|0|0|0|5|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

In my case this helped:

<pre class="lang-sh prettyprint-override"><code>$ export LDFLAGS="-L/usr/local/opt/openssl/lib"
$ export CPPFLAGS="-I/usr/local/opt/openssl/include"
</code></pre>

Then:

<pre class="lang-sh prettyprint-override"><code>gem install mysql2 -v '0.5.2' --source 'https://rubygems.org/' -- --with-cppflags=-I/usr/local/opt/openssl/include --with-ldflags=-L/usr/local/opt/openssl/lib
</code></pre>

Result:

<pre><code>Building native extensions with: '--with-cppflags=-I/usr/local/opt/openssl/include --with-ldflags=-L/usr/local/opt/openssl/lib'
This could take a while...
Successfully installed mysql2-0.5.2
Parsing documentation for mysql2-0.5.2
Installing ri documentation for mysql2-0.5.2
Done installing documentation for mysql2 after 0 seconds
1 gem installed
</code></pre>

<a href="https://qiita.com/HrsUed/items/ca2e0aee6a2402571cf6" rel="nofollow noreferrer">See this post</a> (WARNING: Japanese language inside).

blocks|key|442963|text|我在Windows+7上发布了这个问题。这显然是一个不兼容的问题，解决方案如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442964|从旧的libmySQL.dll安装程序下载InstantRails文件。它可以从InstantRails+GitHub回购获得。|offset|length|style|CODE|442965|接下来，将该文件复制到Ruby/bin文件夹中。|442966|现在，你可以走了；|442967|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/drnic/instantrails/blob/master/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll^0|0|3|C|14|L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

I had this issue on Windows 7. This is apparently an incompatibility issue and the solution is as follows:

Download the <code>libmySQL.dll</code> file from an older InstantRails installer. It is available from the <a href="https://github.com/drnic/instantrails/blob/master/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll" rel="nofollow noreferrer">InstantRails GitHub repo</a>.

Next, copy that file into your Ruby/bin folder.

Now, you are good to go ;)

blocks|key|1640383|text|我也有这个错误。通过安装开发包解决。我用的是arch，它是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1640384|sudo+pacman+-S+base-devel|code-block|syntax|javascript|1640385|安装如下：|1640386|m4,+autoconf,+automake,+bison,+fakeroot,+flex,+libmpc,+ppl,+cloog-ppl,+elfutils,+gcc,
libtool,+make,+patch,+pkg-config|1640387|但我认为它实际上需要制造和gcc。错误输出显示(在我的机器上，除其他外)：|1640388|“您必须首先安装开发工具。”|1640389|所以这是一个明显的决定，而且很有帮助。|1640390|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I got this error too. Solved by installing development packages. I'm using arch and it was:

<pre><code>sudo pacman -S base-devel
</code></pre>

which installed:

<pre><code>m4, autoconf, automake, bison, fakeroot, flex, libmpc, ppl, cloog-ppl, elfutils, gcc,
libtool, make, patch, pkg-config
</code></pre>

but I think it actually needed make and gcc. Error output said (on my machine, among other):

"You have to install development tools first."

So it was an obvious decision and it helped.

blocks|key|443349|text|您必须安装一些依赖项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|443350|sudo+apt-get+install+libmysql-ruby+libmysqlclient-dev|code-block|syntax|javascript|443351|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You have to Install some dependencies

<pre><code>sudo apt-get install libmysql-ruby libmysqlclient-dev
</code></pre>

blocks|key|1641004|text|我可以看到，大多数人已经找到了解决这个问题的方法，这主要是通过但不限于丢失的包，这发生在我清除mysql并重新安装它之后。为了解决我的问题，我不得不运行这个命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1641005|sudo+apt-get+install+libmysqlclient-dev|offset|length|style|CODE|1641006|这个命令帮助我解决了我的问题|1641007|entityMap^0|0|0|13|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I can see most of the people have found the solution to this problem, this is mostly coused but not limited to missing packages, this happened to me after I have purged mysql and reinstalled it. I had to run this command in order to fix my problem:
<code>sudo apt-get install libmysqlclient-dev</code>
This command helped me fix my problem

blocks|key|1640353|text|我在我的mac上遇到了这个错误，我发现我需要从mysql升级到mysql+64位，才能让这个错误消失。我在英特尔macbook+pro上运行OSX10.6，上面有ruby+1.9.2和rails3.0.0|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1640354|我还需要安装xcode，以便获得编译gem所需的unix实用程序(如"make“)。|1640355|完成此操作后，我就能够运行gem、安装mysql和gem安装mysql2，而不会出错。|1640356|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I was running into this error on my mac and found that I needed to upgrade from mysql 32bit to mysql 64 bit to get this error to go away. I was running OSX 10.6 on an intel macbook pro with ruby 1.9.2 and rails3.0.0 

I also needed to install xcode in order to get unix utilities like "make" that are required to compile the gem.

once this was done I was able to run gem install mysql and gem install mysql2 without error.

blocks|key|1995574|text|我获得了在MacOSX10.6.6×1)上构建的gem+(确保安装了开发人员工具包)，2)从Source+3下载当前的MySQL包(在我的例子中是5.5.8)，从cmake.org+4中安装cmake工具)，遵循安装源代码第2.11节中的说明，从mysql发行版文件5)成功构建的sudo+gem+install+mysql2+--+--srcdir=/usr/local/mysql/include，但是在rdoc和ri抱怨的文档中有两个错误。但是现在当我试图要求'mysql2‘时，我得到了一个|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1995575|LoadError:+no+such+file+to+load+--+mysql2/mysql2|code-block|syntax|javascript|1995576|我希望我会遇到的错误是无法找到libmysqlclient.16.dylib，因为我们在另一篇文章(搜索install_name_tool)中发现了这个错误。|1995577|我的$PATH中有/usr/local/mysql+(这是我的源文件和构建的文件所在的地方)，所以我有点为难。如果有人有任何想法的话，我睡几个小时后再检查。|1995578|entityMap^0|3W|1O|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

I got the gem built on Mac OS X 10.6.6 by
1) Ensuring the Developer tools package is installed
2) Downloading the current MySQL package (5.5.8 in my case) from Source
3) Installing the cmake tool from cmake.org
4) Following the instructions in section 2.11 of INSTALL-SOURCE from the mysql distribution files
5) <code>sudo gem install mysql2 -- --srcdir=/usr/local/mysql/include</code>
The gem built successfully, but there are two errors in the documentation that rdoc and ri complain about.
But now when I try to require 'mysql2' I get a 

<pre><code>LoadError: no such file to load -- mysql2/mysql2
</code></pre>

I was hoping the error I would get was that the libmysqlclient.16.dylib couldn't be found because we figured that out in another post (search for install_name_tool).

My $PATH has /usr/local/mysql in it (that's where my source and built files are located), so I'm a little stumped. If anyone has any thoughts, I'll check back after a few hours of sleep.

blocks|key|1995961|text|对于windows用户:设置mysql的库和包含路径，例如，如果您使用xampp，您可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1995962|gem+install+mysql2+--+'--with-mysql-lib="C:\xampp\mysql\lib"+--withmysql-include="C:\xampp\mysql\include"'|code-block|syntax|javascript|1995963|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For windows user:
You set the lib and include path of your mysql, for instance, if youre using xampp you can have like this:

<pre><code>gem install mysql2 -- '--with-mysql-lib="C:\xampp\mysql\lib" --withmysql-include="C:\xampp\mysql\include"'
</code></pre>

blocks|key|443399|text|解决方案只适用于Mac+|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|443400|如果你用自制软件安装了MySQL，那么对我来说最有效的是卸载MySQL，并通过MySQL网站(https://www.mysql.com/)安装MySQL社区版。|443401|安装后，只要重新输入命令到gem+install+mysql2，或者如果必要的话，sudo+gem+install+mysql2，如果您遇到了权限被拒绝的问题。|CODE|443402|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mysql.com/^0|0|C|0|1B|M|0|0|D|I|15|N|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@$9|W|A|X|1|Y]]|E|$]]|$1|H|3|I|5|6|7|Z|8|@$9|10|A|11|B|J]|$9|12|A|13|B|J]]|D|@]|E|$]]|$1|K|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Solution only works on Mac OS X

If you've installed MySQL with homebrew, what worked for me was uninstalling MySQL, and installing MySQL Community Edition via the MySQL website (<a href="https://www.mysql.com/" rel="nofollow noreferrer">https://www.mysql.com/</a>). 

After installed, just re-enter the command to <code>gem install mysql2</code> or if necessary, <code>sudo gem install mysql2</code>, if you are getting permission denied problems.

blocks|key|1640549|text|如果仍有错误，请按照Rails+3+on上的mysql2+gem安装步骤-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1640550|http://rorguide.blogspot.com/2011/03/installing-mysql2-gem-on-ruby-192-and.html|offset|length|1640551|大多数用户都能够安装mysql2+gem。|1640552|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|27|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

If still getting error then follow the steps of mysql2 gem installation on Rails 3 on - 

<a href="http://rorguide.blogspot.com/2011/03/installing-mysql2-gem-on-ruby-192-and.html" rel="nofollow">http://rorguide.blogspot.com/2011/03/installing-mysql2-gem-on-ruby-192-and.html</a>

where most of the user were able to install mysql2 gem.

blocks|key|443061|text|在纠正了mysql-dev问题后，可能需要删除糟糕的mysql2安装。仔细查看$+bundle安装后的消息。你可能需要|type|unstyled|depth|inlineStyleRanges|entityRanges|data|443062|rm+-rf+vendor/cache/
rm+-rf+./Zentest|code-block|syntax|javascript|443063|这将清除糟糕的mysql2安装，以便最终的$+bundle安装可以创建一个良好的安装。|443064|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

After you get the mysql-dev issues corrected, you may need to remove the bad mysql2 install. Look carefully at the messages after $ bundle install. You may need to 

<pre><code>rm -rf vendor/cache/
rm -rf ./Zentest
</code></pre>

This will clear out the bad mysql2 installation so that a final $ bundle install can create a good one.

blocks|key|1640665|text|下载正确版本的mysqllib.dll，然后将其复制到ruby真正适合我的地方。遵循此链接plases+mysql2+gem编译错误的mysql客户端库|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1640666|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/8740868/mysql2-gem-compiled-for-wrong-mysql-client-library^0|1G|O|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]]]]

download the right version of mysqllib.dll then copy it to ruby bin really works for me. Follow this link plases <a href="https://stackoverflow.com/questions/8740868/mysql2-gem-compiled-for-wrong-mysql-client-library">mysql2 gem compiled for wrong mysql client library</a>

blocks|key|1995815|text|得到了“您必须首先安装开发工具”。升级到Mac山区狮子mysql2+后试图安装时出错。显然，这样做可以删除命令行编译器。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1995816|修复：|1995817|我卸载了我非常旧版本的Xcode+(在/Developer/Library中运行卸载脚本)。然后删除/Developer目录。|unordered-list-item|1995818|转到AppStore并下载Xcode。|1995819|启动Xcode并进入Preferences+->下载，并安装了命令行工具。|1995820|entityMap^0|Y|Q|0|0|3|0|0|1R|0|0|J|0|0|11|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|K|3|L|5|J|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|M|3|N|5|J|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|P|$]]

Got the "You have to install development tools first." error when trying to install the mysql2 gem after upgrading to Mac OS X Mountain Lion. Apparently doing this upgrade removes the command line compilers.

To fix:

<ul>
<li>I uninstalled my very old version of Xcode (ran the uninstall script in /Developer/Library). Then deleted the /Developer directory.</li>
<li>Went to the AppStore and downloaded Xcode.</li>
<li>Launched Xcode and went into the Preferences -> Downloads, and installed the command line tools.</li>
</ul>

blocks|key|1640771|text|您之所以会遇到这个问题，是因为您没有安装MySql。在安装mysql2+gem之前。安装MySQL。在此之后，将安装mysql2+gem。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1640772|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You are getting this problem because you have not install MySql. Before install mysql2 gem. Install MySQL. After that mysql2 gem will install.

blocks|key|1640794|text|我只是想专门为Mac用户添加这个答案，。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1640795|在我更新我的xcode之前，我的服务器运行得非常好。启动我的rails服务器时，错误如下图所示|1640796|Gem::Installer::ExtensionBuildError:+ERROR:+Failed+to+build+gem+native+extension.

++++/Users/user/.rvm/rubies/ruby-1.9.3-p448/bin/ruby+extconf.rb+--with-mysql-
++++checking+for+rb_thread_blocking_region()...+/Users/user/.rvm/rubies/ruby-1.9.3-++
++++p448/lib/ruby/1.9.1/mkmf.rb:381:in+`try_do':+The+compiler+failed+to+generate+an++++
++++executable+file.+(RuntimeError)|code-block|syntax|javascript|1640797|还有人建议在错误消息的末尾安装mysql2+gem。因此，当我尝试安装它时，我得到了这个问题中提到的错误。我得到的错误如下|1640798|ERROR:++Error+installing+mysql2:
ERROR:+Failed+to+build+gem+native+extension.|1640799|因此，正如在这篇文章中所建议的那样，我尝试过'brew安装mysql‘，并且放弃了，说mysql版本已经安装好了。但它之前有警告说|1640800|Warning:+You+have+not+agreed+to+the+Xcode+license.
Builds+will+fail!+Agree+to+the+license+by+opening+Xcode.app+or+running:
xcodebuild+-license|1640801|然后，我尝试了这个sudo+xcodebuild+-license，并键入‘同意’在结尾。你得是根根才能同意许可证。|CODE|1640802|在此之后，我再次尝试了bundle安装，然后一切正常工作。即使是因为xcode的更新，我的塔也有问题。|1640803|entityMap^0|7|C|0|0|0|0|0|0|0|9|O|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|15|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|16|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|18|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|19|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|1A|8|@$9|1B|A|1C|B|W]]|D|@]|E|$]]|$1|X|3|Y|5|6|7|1D|8|@]|D|@]|E|$]]|$1|Z|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|10|$]]

I just wanted to add this answer specifically for Mac Users.

My server was running perfectly fine until I updated my xcode. The while starting my rails server the error was shown like this

<pre><code>Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

 /Users/user/.rvm/rubies/ruby-1.9.3-p448/bin/ruby extconf.rb --with-mysql-
 checking for rb_thread_blocking_region()... /Users/user/.rvm/rubies/ruby-1.9.3- 
 p448/lib/ruby/1.9.1/mkmf.rb:381:in `try_do': The compiler failed to generate an 
 executable file. (RuntimeError)
</code></pre>

And there was suggestion to install mysql2 gem at the end of the error message. So when i tried installing it I got the error as above mentioned in this question. The error I got is as follows 

<pre><code>ERROR: Error installing mysql2:
ERROR: Failed to build gem native extension.
</code></pre>

So as suggested in this post I tried 'brew install mysql' and that quitted saying that mysql version so and so already installed. But there was warning before it saying

<pre><code>Warning: You have not agreed to the Xcode license.
Builds will fail! Agree to the license by opening Xcode.app or running:
xcodebuild -license
</code></pre>

Then I tried this <code>sudo xcodebuild -license</code> and type 'agree' at the end. You have to be root to agree to the license.

After this, I again tried bundle install and then everything is working fine as normal. [ Even due to this xcode updation, I had problem with my tower also.]

blocks|key|1640911|text|libmysql-ruby已被逐步淘汰和替换。新命令：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1640912|+sudo+apt-get+install+ruby-mysql+libmysqlclient-dev|code-block|syntax|javascript|1640913|entityMap^0|0|D|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<code>libmysql-ruby</code> has been phased out and replaced. New command:

<pre><code> sudo apt-get install ruby-mysql libmysqlclient-dev
</code></pre>

blocks|key|1996184|text|在ubuntu20.04LTS下，这是唯一对我有用的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1996185|sudo+apt-get+install+ruby-mysql2|code-block|syntax|javascript|1996186|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Under ubuntu 20.04 LTS it's the only solution that have been working for me:
<pre><code>sudo apt-get install ruby-mysql2
</code></pre>

blocks|key|1996224|text|根据https://github.com/brianmario/mysql2/issues/1175的说法，我用|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1996225|gem+install+mysql2+--+\
+--with-mysql-lib=/usr/local/Cellar/mysql/8.0.26/lib+\
+--with-mysql-dir=/usr/local/Cellar/mysql/8.0.26+\
+--with-mysql-config=/usr/local/Cellar/mysql/8.0.26/bin/mysql_config+\
+--with-mysql-include=/usr/local/Cellar/mysql/8.0.26/include|code-block|syntax|javascript|1996226|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/brianmario/mysql2/issues/1175^0|2|1C|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

According to <a href="https://github.com/brianmario/mysql2/issues/1175" rel="nofollow noreferrer">https://github.com/brianmario/mysql2/issues/1175</a> , I fixed it by
<pre class="lang-sh prettyprint-override"><code>gem install mysql2 -- \
 --with-mysql-lib=/usr/local/Cellar/mysql/8.0.26/lib \
 --with-mysql-dir=/usr/local/Cellar/mysql/8.0.26 \
 --with-mysql-config=/usr/local/Cellar/mysql/8.0.26/bin/mysql_config \
 --with-mysql-include=/usr/local/Cellar/mysql/8.0.26/include
</code></pre>

blocks|key|1996263|text|Windows用户的更新解决方案。我在跑步|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1996264|Windows+10|offset|length|style|BOLD|1996265|MySql+8.0.30|1996266|Ruby3.1.2|1996267|我的Ruby版本是来自rubyinstaller.org的版本，其中包含了MYSYS|1996268|我下载了一个MariaDB+C连接器库MariaDB文件v3.1.17，运行它并将相关文件安装在Program中的一个目录中。我将该目录复制到另一个位置，将其重命名为没有任何空格，并运行以下命令：|1996269|gem+install+mysql2+--platform=ruby+--+--with-mysql-dir="c:/my-mariadb-connector-path-with-no-spaces"|code-block|syntax|javascript|1996270|这给了我一个有用的宝石。|1996271|这是库的一个特定版本，而不是最近的版本。在MariaDB网站上查找下载选项有点让人费解，下面是直接下载链接。|1996272|https://dlm.mariadb.com/2319542/Connectors/c/connector-c-3.1.17/mariadb-connector-c-3.1.17-win64.msi|1996273|在我讲到这一点之前，我尝试过几件没用的事情。我已经将它们作为背景信息包含在下面，但是如果您感兴趣的只是一个可行的解决方案，那么您现在可以停止阅读了。|1996274|一些来源建议，如果安装了MYSYS，可以使用以下命令构建gem：|1996275|ridk+exec+gem+install+mysql2+--platform=ruby+--+--use-system-libraries|1996276|这不是为我编写的。|1996277|您可能还看到了下载MySQl连接器库存档版本(+6.1+)的建议。我尝试过这样做，gem编译了，但是当我尝试启动我的应用程序时，我收到了一条错误消息：“不正确的MySQL客户端库版本！这个gem是为6.1.11编译的，但是客户机库是10.5.5。”|1996278|在MySQL、V8和更高版本中，C库不再是可选的额外功能，而是包含在主安装中。我找到了相关的文件，将它们复制到一个无空格目录路径，并尝试了通常的命令。再次，创业板编译，但应用程序无法启动。这一次，错误消息说：“这个gem是为8.0.30编译的，但是客户端库是10.5.5”|1996279|我还试用了MariaDB库的最新版本。有了这个错误消息，gem是为10.6.8编译的。您需要上面描述的特定版本，是的，即使您使用的是发布的“原始”MariaDB，它也确实是您需要的一个MySql库。|1996280|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|A|0|0|C|0|0|9|0|0|0|0|0|0|0|2S|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1M|8|@$D|1N|E|1O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1P|8|@$D|1Q|E|1R|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1S|8|@$D|1T|E|1U|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1V|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1W|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1X|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|20|8|@]|9|@$D|21|E|22|1|23]]|A|$]]|$1|10|3|11|5|6|7|24|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|25|8|@]|9|@]|A|$]]|$1|14|3|15|5|R|7|26|8|@]|9|@]|A|$S|T]]|$1|16|3|17|5|6|7|27|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|28|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|29|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2A|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]]|1F|$1G|$5|1H|1I|1J|A|$1K|Z]]]]

An updated solution for Windows users. I am running
Windows 10
MySql 8.0.30
Ruby 3.1.2
My Ruby version is the one from rubyinstaller.org with the MYSYS devkit included
I downloaded a MariaDB C connector library msi installer file v3.1.17, ran it and it installed the relevant files in a directory in Program Files. I copied that directory to another location, renamed it so that it didn't have any spaces and ran the command:
<pre><code>gem install mysql2 --platform=ruby -- --with-mysql-dir=&quot;c:/my-mariadb-connector-path-with-no-spaces&quot;
</code></pre>
This gave me a functioning gem.
This is a specific version of the library and not the most recent. Finding your way around the download options on the MariaDB website is a bit confusing, so here is the direct download link.
<a href="https://dlm.mariadb.com/2319542/Connectors/c/connector-c-3.1.17/mariadb-connector-c-3.1.17-win64.msi" rel="nofollow noreferrer">https://dlm.mariadb.com/2319542/Connectors/c/connector-c-3.1.17/mariadb-connector-c-3.1.17-win64.msi</a>
Before I got to this point I'd tried several things which hadn't worked. I've included them below as background information, but if all you're interested in is a working solution then you can stop reading now.
A few sources suggest that if you have the MYSYS devkit installed you can build the gem with the following command:
<pre><code>ridk exec gem install mysql2 --platform=ruby -- --use-system-libraries
</code></pre>
This did not compile for me.
You may also have seen a recommendation to download an archived version - 6.1 - of the MySQl connector library. I tried this, the gem compiled, but when I tried to start my app I got an error message: &quot;Incorrect MySQL client library version! This gem was compiled for 6.1.11 but the client library is 10.5.5.&quot;
In MySQL V8 and above the C library is no longer an optional extra but is included in the main installation. I found the relevant files, copied them to a no spaces directory path and tried the usual command. Again the gem compiled but the app wouldn't start. This time the error message said that &quot;This gem was compiled for 8.0.30 but the client library is 10.5.5&quot;
I also tried the latest version of of the MariaDB library. With that the error message said that the gem was compiled for 10.6.8. You need the specific version described above, and yes, it really is a MariaDB library you need even if you're using &quot;Original&quot; MySql as distributed by the Oracle Corporation

blocks|key|1641178|text|从这里下载连接器C文件。(https://downloads.mysql.com/archives/c-c/)|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|offset|length|data|1641179|将文件解压缩到某个位置，如C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib|1641180|使用此模板|1641181|gem安装mysql2|unstyled|1641182|我安装的位置是lib_location+->+C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib|style|BOLD|1641183|gem安装'--with-mysql-lib="C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib“--with-mysql-include="C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\include"‘mysql2|1641184|entityMap|0|LINK|mutability|MUTABLE|url|https://downloads.mysql.com/archives/c-c/^0|D|15|0|0|0|0|0|7|C|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@]|C|$]]|$1|K|3|L|5|J|7|15|8|@$A|16|B|17|M|N]]|9|@]|C|$]]|$1|O|3|P|5|J|7|18|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|J|7|19|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

<ol>
<li>Download the connector C file from [here][1]. (https://downloads.mysql.com/archives/c-c/)
</li>
<li>Extract the file to a location, like C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib
</li>
<li>Use this template
</li>
</ol>
gem install mysql2 -- '--with-mysql-lib=&quot;$lib_location&quot; --with-mysql-include=&quot;$include_location&quot;'
eg: My installed location is lib_location -&gt; C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib
gem install mysql2 -- '--with-mysql-lib=&quot;C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\lib&quot; --with-mysql-include=&quot;C:\ror\mysqlC\mysql-connector-c-6.1.11-winx64\include&quot;'

I am having some problems when trying to install <code>mysql2</code> gem for Rails. When I try to install it by running <code>bundle install</code> or <code>gem install mysql2</code> it gives me the following error:

<blockquote>
 Error installing mysql2: ERROR: Failed to build gem native extension.
</blockquote>

How can I fix this and successfully install <code>mysql2</code>?

Error installing mysql2: Failed to build gem native extension

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

在为Rails安装mysql2 gem时，我遇到了一些问题。当我试图通过运行bundle install或gem install mysql2来安装它时，它会给出以下错误：安装mysql2时出错:错误:生成gem本机扩展失败。如何修复此问题并成功安装mysql2？

问安装mysql2时出错:无法构建gem本机扩展
EN

回答 31

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问安装mysql2时出错:无法构建gem本机扩展EN

回答 31

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问安装mysql2时出错:无法构建gem本机扩展
EN