# Mysql warning

**URL:** <https://www.ruby-forum.com/t/mysql-warning/154711>\
**Category:** Rails\
**Created:** [December 3, 2008, 6:20am UTC](https://www.ruby-forum.com/t/mysql-warning/154711 "2008-12-03T06:20:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nilez](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/34f0e0/32.png) [@nilez](https://www.ruby-forum.com/u/nilez)\
**Post date:** [December 3, 2008, 6:20am UTC](https://www.ruby-forum.com/t/mysql-warning/154711/1 "2008-12-03T06:20:04Z")

</div>

Hi everyone.

In development.log one message always appears as

- WARNING: You’re using the Ruby-based MySQL library that ships with  
Rails.  
This library is not suited for production. Please install the C-based  
MySQL  
library instead (gem install mysql).\*

Though I have installed mysql using the command(gem install mysql). Can  
anyone tell me why it is coming as warning?

Thanks,  
Nilesh.

---

<div class="post-metadata">

**Author:** ![nilez](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/34f0e0/32.png) [@nilez](https://www.ruby-forum.com/u/nilez)\
**Post date:** [December 3, 2008, 12:01pm UTC](https://www.ruby-forum.com/t/mysql-warning/154711/2 "2008-12-03T12:01:44Z")

</div>

On 03 Dec 2008, at 06:19, Nilesh K. wrote:

> In development.log one message always appears as
> 
> WARNING: You’re using the Ruby-based MySQL library that ships with  
> Rails. This library is not suited for production. Please install the  
> C-based MySQL library instead (gem install mysql).
> 
> Though I have installed mysql using the command(gem install mysql).  
> Can anyone tell me why it is coming as warning?

Means it isn’t installed properly. On most operating systems, just  
doing “gem install mysql” won’t work properly anyway, because you need  
sudo privileges to do it. “sudo gem install mysql” should work better.  
Also make sure you pick the right version (win-32 if you use windows).  
In these cases it’s better to mention your operating system in your  
post, now we can only guess what you are using.

Best regards

Peter De Berdt

---

<div class="post-metadata">

**Author:** ![nilez](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/34f0e0/32.png) [@nilez](https://www.ruby-forum.com/u/nilez)\
**Post date:** [December 3, 2008, 12:55pm UTC](https://www.ruby-forum.com/t/mysql-warning/154711/3 "2008-12-03T12:55:46Z")

</div>

Hi Peter. I am using XP OS and MySql server version is 5.0.41. Ruby’s  
version: 1.8.6 and Rails version: 2.2.2

---

<div class="post-metadata">

**Author:** ![nilez](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/34f0e0/32.png) [@nilez](https://www.ruby-forum.com/u/nilez)\
**Post date:** [December 3, 2008, 5:19pm UTC](https://www.ruby-forum.com/t/mysql-warning/154711/4 "2008-12-03T17:19:07Z")

</div>

From irb, try ‘require mysql’. If you get true, then it should be  
installed  
correctly.

BTW, I have the same configuration as well, and I tried Mysql 5.1, and  
it  
did not work. I had to go back to 5.0.x

Kaushik