Ruby on Rails: "无法启动此程序，因为计算机中丢失LIBMYSQL.dll"问题解决

转自：http://blog.csdn.net/abbuggy/article/details/7405192

遇到了一样的问题，直接把博文借过来用了。

我的电脑使用Ruby on Rails与MySQL连接时，会提示“无法启动此程序，因为计算机中丢失LIBMYSQL.dll。尝试重新安装程序以解决此问题”（This application has failed to start because LIBMYSQL.DLL was not found.）的错误。

软件版本：

[plain] view plain copy

1. Win7 64位  
2. E:\greensoft\RailsInstaller>mysql -v  
3. Server version: 5.5.17 MySQL Community Server (GPL)  
4.   
5. E:\greensoft\RailsInstaller>ruby -v  
6. ruby 1.9.3p125 (2012-02-16) [i386-mingw32]  
7. E:\greensoft\RailsInstaller>rails -v  
8. Rails 3.2.1  
9. E:\greensoft\RailsInstaller>gem list mysql2  
10. mysql2 (0.3.11 x86-mingw32)  

尝试过将MySQL\MySQL Server 5.5\lib下的libmysql.dll和libmysql.lib拷贝到Ruby/bin中。报错换成

[plain] view plain copy

1. E:\greensoft\RailsInstaller\Sites\simple_site>rails server  
2. E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/mysql2.rb:2:in `require': 193: %1 不是有效的 Win32 应用程序。   - E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/1.9/mysql2.so (LoadError)  
3.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/mysql2.rb:2:in `<top (required)>'  
4.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2.rb:9:in `require'  
5.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2.rb:9:in `<top (required)>'  
6.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:68:in `require'  
7.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:68:in `block (2 levels) in require'  
8.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:66:in `each'  
9.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:66:in `block in require'  
10.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:55:in `each'  
11.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler/runtime.rb:55:in `require'  
12.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.0.22/lib/bundler.rb:122:in `require'  
13.     from E:/greensoft/RailsInstaller/Sites/simple_site/config/application.rb:7:in `<top (required)>'  
14.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/railties-3.2.1/lib/rails/commands.rb:53:in `require'  
15.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/railties-3.2.1/lib/rails/commands.rb:53:in `block in <top (required)>'  
16.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/railties-3.2.1/lib/rails/commands.rb:50:in `tap'  
17.     from E:/greensoft/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/railties-3.2.1/lib/rails/commands.rb:50:in `<top (required)>'  
18.     from script/rails:6:in `require'  
19.     from script/rails:6:in `<main>  

后来才知道这是由于32位的Ruby与64位的MySQL的不兼容造成的。

不用重装操作系统，也不用重装MySQL，使用32位的MySQL connector来屏蔽这些问题。下载时请看清32位windows的zip版本。
http://dev.mysql.com/downloads/connector/c/

下载下来解压缩，将lib目录下的libmysql.dll和libmysql.lib拷贝到Ruby/bin目录下。问题解决！

[plain] view plain copy

1. E:\greensoft\RailsInstaller\Sites\simple_site>rails server  
2. => Booting WEBrick  
3. => Rails 3.2.1 application starting in development on http://0.0.0.0:3000  
4. => Call with -d to detach  
5. => Ctrl-C to shutdown server  
6. [2012-03-29 00:33:30] INFO  WEBrick 1.3.1  
7. [2012-03-29 00:33:30] INFO  ruby 1.9.3 (2012-02-16) [i386-mingw32]  
8. [2012-03-29 00:33:30] INFO  WEBrick::HTTPServer#start: pid=4596 port=3000