MySQL errors on Cygwin - URGENT!

Rails
1

Hi,

when I type script/server, I am receiving the following error:

!!! The bundled mysql.rb driver has been removed from Rails 2.2.
Please install
the mysql gem and try again: gem install mysql.

And if I type gem install mysql, I get the following error:

ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

    /usr/bin/ruby.exe extconf.rb

checking for mysql_query() in -lmysqlclient… no
checking for main() in -lm… yes
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lz… yes
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lsocket… no
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lnsl… no
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lmygcc… no
checking for mysql_query() in -lmysqlclient… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Any ideas, would be much appreciated.

James

2

On Thu, Nov 03, 2011 at 05:13:37PM -0700, James S. wrote:

“Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.”

Any ideas, would be much appreciated.

What have you looked at so far?

Did you read the error message? Do you have the MySQL headers
installed?

Peter

3

Which environment you are using…let me know the OS especially…

4

Cygwin is basically *nix (Linux?) on top of windows.

J.

5

I came across this problem several days ago,I’m using
windowsxp ,Here is my solution. 1. edit Gemfile => gem ‘mysql2’,
‘0.2.6’ 2. download mysql-noinstall-5.1.50-win32.zip athttp://
downloads.mysql.com/archives/mysql-5.1/mysql-
noinstall-5.1.50-…,unzip 3. gem install mysql2 -v 0.2.6 – –
with-mysql-lib=E:\ROR\mysql-5.1.50-win32\lib --with-mysql-include=E:
\ROR\mysql-5.1.50-win32\include (replace the file “E:\ROR
\mysql-5.1.50-win32” path withyours) 4. this should work now,try
bundle install,generate somemodel ,and run rake db:migrate to see
if it works,make sure yourdatabase config is right,like
thisdevelopment: adapter: mysql2 encoding: utf8 reconnect:
false database: depot_development pool: 5 username: root
password: root host: localhost 5.if it still not work ,try this
=> Issues · brianmario/mysql2 · GitHub this helped.