I am looking to get MySQL installed towards the latest version because of some installation failing somewhere across the line. I run the command jewel install mysql and that i get the following:

Building native extensions. This could require sometime... ERROR: Error setting up mysql: ERROR: Unsuccessful to build jewel native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:7: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 mkmf.rb aren't able to find header files for ruby at /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ruby.h

Jewel files will stay set up in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection. Results drenched to /Library/Ruby/Gems/1.8/gems/mysql-2.8.1/ext/mysql_api/jewel_make.out

I have looked, and attempted lots of things, from setting up specific versions to attempting to re-install ruby with no luck.

Any ideas where I might be failing?

I am looking to get MySQL installed towards the latest version because of some installation failing somewhere across the line. I run the command jewel install mysql and that i get the following:

Building native extensions. This could require sometime... ERROR: Error setting up mysql: ERROR: Unsuccessful to build jewel native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:7: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 mkmf.rb aren't able to find header files for ruby at /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ruby.h

Jewel files will stay set up in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection. Results drenched to /Library/Ruby/Gems/1.8/gems/mysql-2.8.1/ext/mysql_api/jewel_make.out

I have looked, and attempted lots of things, from setting up specific versions to attempting to re-install ruby with no luck.

Any ideas where I might be failing?

EDIT: I installed XCode off my Snow Leopard DVD and also the error just transformed slightly towards the following:

Building native extensions. This may require sometime... ERROR: Error setting up mysql: ERROR: Unsuccessful to construct jewel native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:4: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:7: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 extconf.rb:17: warning: Insecure world writable dir /usr/bin in PATH, mode 040777 checking for mysql_query() in -lmysqlclient... no checking for primary() in -lm... yes checking for mysql_query() in -lmysqlclient... no checking for primary() in -lz... yes checking for mysql_query() in -lmysqlclient... no checking for primary() in -lsocket... no checking for mysql_query() in -lmysqlclient... no checking for primary() in -lnsl... no checking for mysql_query() in -lmysqlclient... no checking for primary() in -lmygcc... no checking for mysql_query() in -lmysqlclient... no * extconf.rb unsuccessful * Couldn't create Makefile because of some reason, most likely insufficient necessary libraries and/or headers. Look into the mkmf.log apply for more particulars. You might need configuration options.

Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include --without-opt-include=$/include --with-opt-lib --without-opt-lib=$/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby --with-mysql-config --without-mysql-config --with-mysql-dir --without-mysql-dir --with-mysql-include --without-mysql-include=$/include --with-mysql-lib --without-mysql-lib=$/lib --with-mysqlclientlib --without-mysqlclientlib --with-mlib --without-mlib --with-mysqlclientlib --without-mysqlclientlib --with-zlib --without-zlib --with-mysqlclientlib --without-mysqlclientlib --with-socketlib --without-socketlib --with-mysqlclientlib --without-mysqlclientlib --with-nsllib --without-nsllib --with-mysqlclientlib --without-mysqlclientlib --with-mygcclib --without-mygcclib --with-mysqlclientlib --without-mysqlclientlib

Jewel files will stay set up in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection. Results drenched to /Library/Ruby/Gems/1.8/gems/mysql-2.8.1/ext/mysql_api/jewel_make.out

doing "which mysql" around the command line returns nothing, meaning it isn't realizing it. I additionally installed the MySQL system preferences option, and that i can't stop MySQL from running. Now I am completely stuck as how to proceed!

EDIT EDIT

I have just completely reinstalled MySQL by using this guide http://hivelogic.com/articles/setting up-mysql-on-mac-os-x

Regrettably this did not work either, I still get the same errors. I can not even do mysql -uroot in the command line, I recieve the mistake of:

ERROR 2002 (HY000): Can't connect with local MySQL server through socket '/tmp/mysql.sock' (2)

And So I think I have attempted everything.

*SOLVED

Sorry men, the reason behind this no longer working was due to the MySQL pathways. I have blogged onto it here: http://world wide web.kieransenior.co.united kingdom/2010/02/04/mysql-cant-connect-using-ruby-on-rails-mac-os-x-snow-leopard/