mysql - Ruby mysql2 Error

Question

I am getting the following error

C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require': 126: The specified module could not be found.   - C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.9/mysql2.so (LoadError)

When trying to run this script...

require "mysql2"

client = Mysql2::Client.new(:host => "localhost", :username => "root", :password => "system32")
results = client.query("SELECT * FROM project1_nodes").each do |row|
  puts row
end

Any ideas?

Cheers Martin

Answer 1

I guess you are running ROR on windows. So follow these steps.

1. make sure you installed mysql correctlt.
2. copy libmysql.dll(from mysql installation directory) file into you C:/Ruby193/bin folder
3. now remove older mysql installed gems.
4. reinstall mysql gem.

This might fix your problem.