/ Ruby on Rails
/
class
v3.2.13 - Show latest stable - Superclass: AbstractAdapter

The MySQL adapter will work with both Ruby/MySQL, which is a Ruby-based MySQL adapter that comes bundled with Active Record, and with the faster C-based MySQL/Ruby adapter (available both as a gem and from http://www.tmtm.org/en/mysql/ruby/).

Options:

  • :host - Defaults to “localhost”.

  • :port - Defaults to 3306.

  • :socket - Defaults to “/tmp/mysql.sock”.

  • :username - Defaults to “root”

  • :password - Defaults to nothing.

  • :database - The name of the database. No default, must be provided.

  • :encoding - (Optional) Sets the client encoding by executing “SET NAMES <encoding>” after connection.

  • :reconnect - Defaults to false (See MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html).

  • :sslca - Necessary to use MySQL with an SSL connection.

  • :sslkey - Necessary to use MySQL with an SSL connection.

  • :sslcert - Necessary to use MySQL with an SSL connection.

  • :sslcapath - Necessary to use MySQL with an SSL connection.

  • :sslcipher - Necessary to use MySQL with an SSL connection.

Constants

ADAPTER_NAME = 'MySQL'

ENCODINGS = {\n"armscii8" => nil,\n"ascii" => Encoding::US_ASCII,\n"big5" => Encoding::Big5,\n"binary" => Encoding::ASCII_8BIT,\n"cp1250" => Encoding::Windows_1250,\n"cp1251" => Encoding::Windows_1251,\n"cp1256" => Encoding::Windows_1256,\n"cp1257" => Encoding::Windows_1257,\n"cp850" => Encoding::CP850,\n"cp852" => Encoding::CP852,\n"cp866" => Encoding::IBM866,\n"cp932" => Encoding::Windows_31J,\n"dec8" => nil,\n"eucjpms" => Encoding::EucJP_ms,\n"euckr" => Encoding::EUC_KR,\n"gb2312" => Encoding::EUC_CN,\n"gbk" => Encoding::GBK,\n"geostd8" => nil,\n"greek" => Encoding::ISO_8859_7,\n"hebrew" => Encoding::ISO_8859_8,\n"hp8" => nil,\n"keybcs2" => nil,\n"koi8r" => Encoding::KOI8_R,\n"koi8u" => Encoding::KOI8_U,\n"latin1" => Encoding::ISO_8859_1,\n"latin2" => Encoding::ISO_8859_2,\n"latin5" => Encoding::ISO_8859_9,\n"latin7" => Encoding::ISO_8859_13,\n"macce" => Encoding::MacCentEuro,\n"macroman" => Encoding::MacRoman,\n"sjis" => Encoding::SHIFT_JIS,\n"swe7" => nil,\n"tis620" => Encoding::TIS_620,\n"ucs2" => Encoding::UTF_16BE,\n"ujis" => Encoding::EucJP_ms,\n"utf8" => Encoding::UTF_8,\n"utf8mb4" => Encoding::UTF_8,\n}

Files

  • activerecord/lib/active_record/connection_adapters/mysql_adapter.rb

1Note

Compiling mysql gem in Leopard with MacPorts MySQL

crishoj · Nov 6, 20081 thank

Needs architecture and reference to mysql_config:

sudo env ARCHFLAGS="-arch i386" gem install mysql -- \\
--with-mysql-config=/opt/local/lib/mysql5/bin/mysql_config