# Ruby mysql error

**URL:** <https://www.ruby-forum.com/t/ruby-mysql-error/169252>\
**Category:** Rails\
**Created:** [June 1, 2009, 1:45pm UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252 "2009-06-01T13:45:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gourav](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/278dde/32.png) [@gourav](https://www.ruby-forum.com/u/gourav)\
**Post date:** [June 1, 2009, 1:45pm UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252/1 "2009-06-01T13:45:32Z")

</div>

Hi,

I am getting a mysql error while running a ruby file on my system  
(Windows):

D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read': Client does not support authentication protocol requested by server; consider upgrading MySQL c lient (Mysql::Error) from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real\_connect’  
from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/  
active\_record/connection\_adapters/mysql\_adapter.rb:576:in `connect' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:204:in `initialize’  
from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/  
active\_record/connection\_adapters/mysql\_adapter.rb:76:in `new' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:76:in `mysql\_connectio  
n’  
from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/  
active\_record/connection\_adapters/abstract/connection\_pool.rb:223:in  
`sen d' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:223:in `new  
\_connection’  
from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/  
active\_record/connection\_adapters/abstract/connection\_pool.rb:245:in  
`che ckout_new_connection' ... 16 levels... from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/base.rb:1991:in `all\_attributes\_exists?’  
from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/  
active\_record/base.rb:1847:in `method_missing' from test1.rb:28:in `select\_type’  
from test1.rb:39

I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone  
through google:  
[http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795](http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795)

> <https://stackoverflow.com/questions/436980/has-anyone-successfully-connected-to-mysql-from-ruby>

but it did not help. Do I need to make any configuration for this?

Thanks in advance  
-gourav

---

<div class="post-metadata">

**Author:** ![gourav](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/278dde/32.png) [@gourav](https://www.ruby-forum.com/u/gourav)\
**Post date:** [June 1, 2009, 2:29pm UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252/2 "2009-06-01T14:29:11Z")

</div>

On Jun 1, 4:44 pm, Gourav T. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> ```
> from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
> 
> ```
> 
> active\_record/connection\_adapters/abstract/connection\_pool.rb:223:in  
> … 16 levels…  
> but it did not help. Do I need to make any configuration for this?
> 
> Thanks in advance  
> -gourav

Can you verify if following things are in proper place.

1. Are you able to connect to mysql otherwise on your system.
2. Have you done $gem install mysql
3. Copy libmySQL.dll from MYSQL\_INSTALL/bin forlder to RUBY\_INSTALL/  
bin folder
4. Verify database.yml has your password

vipin

---

<div class="post-metadata">

**Author:** ![gourav](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/278dde/32.png) [@gourav](https://www.ruby-forum.com/u/gourav)\
**Post date:** [June 1, 2009, 3:06pm UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252/3 "2009-06-01T15:06:41Z")

</div>

Thanks for your reply Vipin,

I am able to connect to Mysql through command prompt and mysql query  
browser.

Also, I am able to connect to a remote system by mysql query browser  
tool.  
I have copied ibmySQL.dll from MYSQL\_INSTALL/bin forlder to  
RUBY\_INSTALL/bin folder

I have mysql gem installed 2.7.1

but it still doesn’t work.

-gourav

---

<div class="post-metadata">

**Author:** ![gourav](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/278dde/32.png) [@gourav](https://www.ruby-forum.com/u/gourav)\
**Post date:** [June 1, 2009, 7:31pm UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252/4 "2009-06-01T19:31:45Z")

</div>

The message said, update your MySQL client, reverify your conf file, and  
try  
again. What MySQL version have you?

---

<div class="post-metadata">

**Author:** ![gourav](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/278dde/32.png) [@gourav](https://www.ruby-forum.com/u/gourav)\
**Post date:** [June 3, 2009, 10:56am UTC](https://www.ruby-forum.com/t/ruby-mysql-error/169252/5 "2009-06-03T10:56:57Z")

</div>

Hi Gerardo,  
I am using “MYSQL Ver 14.12 Distrib 5.0.77, for Win32 (ia32)”

Another strange thing I noticed is I am able to run a rails(2.2.2)  
application here, without any issue.

On Jun 1, 9:31 pm, Gerardo Gonzalez C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)