I can't connect mysql with rails

Question

I can't connect mysql to rails ,i have tried to modify database.yml and gemfile but nothing works.Please help.

Rails Environment Configuration

git:
  version:    git version 1.7.6.msysgit.0

ruby:
  bin:        C:/RailsInstaller/Ruby1.9.2/bin/ruby.exe
  version:    ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

rails:
  bin:        C:/RailsInstaller/Ruby1.9.2/bin/rails.bat
  version:    Rails 3.1.1

Process

C:\Sites>cd demo

C:\Sites\demo>rake db:migration
rake aborted!
Incorrect MySQL client library version! This gem was compiled for 6.0.0 but the
client library is 5.0.27.

(See full trace by running task with --tracing)

i have installed mysql 5.5

Post content of `database.yml` and output of `rake db:create` — davidb, Jan 20 '12 at 20:41
any errors that show in your terminal would also be helpful. Sometimes the mysql gem isnt installed or you haven't run rake db:migrate. — jstim, Jan 20 '12 at 20:48
I have run rake db:migrate and says mysql2 adapter is not installed.I have tried bundle install and says mysql2 is not part of the bundle so it cannot be installed.I have tried a lot of things because i have read and other forums but the problem remains. — mario, Jan 20 '12 at 23:55
Until you get the MySQL versioning issue worked out you can use Sqlite; at least you can get started. — Dave Newton, Jan 21 '12 at 13:42

score 0 · Answer 1 · answered Jan 21 '12 at 13:44

0

The problem lies with the Client Library which is libmysql.dll.

Try downloading version 6 from here:

http://dev.mysql.com/downloads/connector/c/

And change your current file with the new one.

answered Jan 21 '12 at 13:44

tommasop

18,495
2
40
51

score 0 · Answer 2 · edited Sep 01 '12 at 21:02

database yml

development:
  adapter: mysql2
  database: railsapp
  encoding: utf8
  username: root
  password: 1234
  pool: 5
  timeout: 5000

test:
  adapter: mysql2
   database: railsapp
   encoding: utf8
   username: root
  password: 1234
  pool: 5
  timeout: 5000

production:
   adapter: mysql2
    database: railsapp
    encoding: utf8
    username: root
  password: 1234
  pool: 5
  timeout: 5000

I can't connect mysql with rails

2 Answers2