Try this:

$ sudo gem install mysql -- --with-mysql-config

If that doesn't work try downloading the tarball of the mysql drivers  
and do this:
extconf.rb --with-mysql-config

HTH-
-Ezra
On Aug 28, 2005, at 4:40 PM, Spiceee wrote:

>  i've fiddled with rails before but since i've just recieved the book,
>  i was going thru the depot app. when 'instant gratification' failed me
>  completely.
> 
>  before starting the chapter, i installed the lastest version of ruby
>  and rails and, before that, installed the new mysql 4.1.14 for
>  windows, which i tested with mysql-front (did the old password thing,
>  all's working, all's swell).
> 
>  then when i tried to scaffold the Product Admin (having created a
>  proper 'products' table), i got a "Before updating scaffolding from
>  new DB schema, try creating a tab
>  le for your model (Product)", which is usually related to rails
>  failing to map a Product model to a 'products' database, right?
> 
>  well, not on my case. i have the database set, the table is set and
>  visible via Mysql-Front of phpmyadmin and ruby is connecting to Mysql,
>  otherwise the last error on the script/generate command would be
>  Access denied, etc, etc.
> 
>  i tried then to update my mysql driver with gem update mysql and  
>  got this error:
> 
>  Upgrading installed gems...
>  Attempting remote upgrade of mysql
>  Attempting remote installation of 'mysql'
>  Building native extensions.  This could take a while...
>  ERROR:  While executing gem ... (RuntimeError)
>      ERROR: Failed to build gem native extension.
>  Gem files will remain installed in c:/ruby/lib/ruby/gems/1.8/gems/ 
>  mysql-
>  inspection.
>    ruby extconf.rb update mysql\nchecking for mysql_query() in  
>  mysqlclien
>   no
>  checking for main() in m.lib... yes
>  checking for mysql_query() in mysqlclient.lib... no
>  checking for main() in z.lib... no
>  checking for mysql_query() in mysqlclient.lib... no
>  checking for main() in socket.lib... no
>  checking for mysql_query() in mysqlclient.lib... no
>  checking for main() in nsl.lib... no
>  checking for mysql_query() in mysqlclient.lib... no
> 
>  i made sure to install mysql 4.1.14 with the libraries... so i'm
>  pretty much stuck. maybe i should downgrade to mysql 4.0?
> 
>  help!
> 
>  spiceee.
>  _______________________________________________
>  Rails mailing list
>  Rails@[...].org
>  http://lists.rubyonrails.org/mailman/listinfo/rails
> 

-Ezra Zygmuntowicz
WebMaster
Yakima Herald-Republic Newspaper
ezra@[...].com
509-577-7732

_______________________________________________
Rails mailing list
Rails@[...].org
http://lists.rubyonrails.org/mailman/listinfo/rails