According to the information here, pure Ruby MySQL doesn't work with
4.1 or 5.x. If that's true, I am not sure if pure Ruby MySQL is of any
use.

http://wiki.rubyonrails.org/rails/pages/MySQL


On Dec 5, 2007 9:04 AM, Venks <venkatesh.mantha / gmail.com> wrote:
> I am not able to make the pure Ruby Mysql driver work. I am getting
> the following error and couldn't figure out why this error is showing
> up. MySQL manual mentions something about old client and password but
> I am using MySQL 5.1 and I have no other version installed previously.
> Of course I never had any issues with the Native Ruby MySQL driver.
> Any ideas?
>
> Error message: Client does not support authentication protocol
> requested by server; consider upgrading MySQL client
>
> On Dec 5, 2007 2:31 AM, Charles Oliver Nutter <charles.nutter / sun.com> wrote:
>
> > Venks wrote:
> > > Below is the error while running with JRuby:
> > >
> > > connection.rb:4: /usr/lib/ruby/gems/1.8/gems/mysql-2.7/mysql.so:0:
> > > Invalid char `\177' in expression (SyntaxError)
> > >         from connection.rb:4:in `require'
> > >         from connection.rb:4
> > >
> > > Is this a compatibility issue between JRuby and MySQL driver writting
> > > in Ruby? Is this expected behaviour or can this be addressed?
> >
> > The pure Ruby MySQL driver should be fine, but it looks like you've got
> > the non-pure-Ruby driver and it's trying to load it. There's a known bug
> > in JRuby that it will try to load .so files as Ruby source (oops), but
> > no amount of magic will make it load native extensions (yet).
> >
> > Make sure you're using a pure Ruby MySQL driver if you want to access SQL.
> >
> > - Charlie
> >
> >
>