Ruby On Rails Using MySQL database On Snow Leopard-优快云博客

本文链接：https://blog.youkuaiyun.com/lxneng/article/details/83530511

本文记录了作者在使用Ruby on Rails框架连接MySQL数据库时遇到的问题及解决过程。主要问题是无法为Rails应用创建MySQL数据库，最终通过卸载并重新安装64位版本的mysql gem解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

又一次折腾！在家折腾Ruby on Rails使用MySQL数据库，可是失败

$ rails blog -d mysql
$ vim blog/config/database.yml
$ cd blog; rake db:create --trace
(in /Users/eric/NetBeans_Workspace/blog)
** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:create
# 出错信息
Couldn't create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"blog_development", "host"=>"127.0.0.1", "pool"=>5, "password"=>"admin", "socket"=>"/tmp/mysql.sock"}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation)

郁闷了，我的配置都正常，问朋友，问google，最后卸载了mysql这个gem再重装64位的mysql gem

$ sudo gem uninstall mysql
$ sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/Cellar/mysql/5.1.41/bin/mysql_config

再cd blog; rake db:create就ok了

ps：我电脑没开启64位呀，奇怪

参考：http://weblog.rubyonrails.org/2009/8/30/upgrading-to-snow-leopard