Mysql issue with rails 3 and Ruby 1.9.2

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

In your Gemfile place:

gem 'mysql'

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

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.

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.

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