Mysql issue with rails 3 and Ruby 1.9.2

Rails
1

Hello,

I am trying to install rails and ruby with latest version. Every thing
is ok, but mysql is not not working. I followed all the google links.
the whole day is failed. any idea…

When I try to use dbconsole, I am getting following error.

Couldn’t find database client: mysql, mysql5. Check your $PATH and try
again.

I checked in gems directory “mysql-2.8.1-x86-mswin32”.

I have downloaded dll file and placed in ruby/bin folder. “libmySQL.dll”

I am using windows vista.

Any help??

Regards
Selva

2

In your Gemfile place:

gem ‘mysql’

In your database.yml file make sure you’ve changed mysql2 to mysql.

====

Make sure that you are using the correct version of mysql and the
correct dll based on 32 bit or 64 bit. Currently, 64 bit has numerous
issues and you should just install the 32 bit version of mysql and use
the 32 bit version of dll.

Place libmySQL.dll in the ruby\bin directory and make sure the bin
directory is listed in your windows path.

Run bundle install.

====

Make sure your mysql path is set appropriately in windows environment.
If installing the 32-bit version, it should automatically setup the
correct path for you. However, if you manually configured everything
you may be missing the correct path to your installation.

PATH should include: C:\Program Files\MySQL\MySQL Server 5.1\bin;

Go to irb and type require ‘mysql’
=> true

3

If you sees that you did not set PATH properly, add mysql directory to
%PATH%. On command line, you should be able to run mysql, if you
can’t, dbconsole won’t be able to run.

4

Do you have Mysql installed? Not the gem, or the dll, but mysql.exe?
If you have it installed, check your environment PATH.
In cmd, try mysql. If it gives you mysql is not recognized...,
then you need to install it.

5

justinbaker wrote in post #978516:

Do you have Mysql installed? Not the gem, or the dll, but mysql.exe?
If you have it installed, check your environment PATH.
In cmd, try mysql. If it gives you mysql is not recognized...,
then you need to install it.

Thanks to all, I am able to connect changing the Gemfile. Thanks Alpha

Regards
Selva