On Ubuntu/Debian and other distributions using aptitude:
sudo apt-get install libmysql-ruby libmysqlclient-dev
On Red Hat/CentOS and other distributions using yum:
sudo yum install mysql-devel
On Mac OS X with Homebrew:
brew install mysql
首先需要注意的是,比较悲剧的,mysql2不支持参数化查询(How do you create prepared statements with the mysql2 gem?,http://stackoverflow.com/questions/9906437/how-do-you-create-prepared-statements-with-the-mysql2-gem)
如果需要这个功能,可以试试 Sequel,The Database Toolkit for Ruby (http://sequel.jeremyevans.net/)
1、先安装依赖的mysql开发库和头文件
On Ubuntu/Debian and other distributions using aptitude:
sudo apt-get install libmysql-ruby libmysqlclient-dev
On Red Hat/CentOS and other distributions using yum:
sudo yum install mysql-devel
On Mac OS X with Homebrew:
brew install mysql
2、安装mysql2
gem install mysql2
client = Mysql2::Client.new(:host => '192.168.222.222', :database => 'db', :username => "root", :password => "xman")
很有可能得到链接被拒绝的错误,错误码(111)。可能的原因是mysql被配置为只监听本地的链接。
登录到数据库所在的机器,查看mysel的配置文件 my.cnf ,如果看到
bind-address = 127.0.0.1
就注释掉,然后重启mysql服务。
直接用root账户链接的话,默认配置下,链接还是会被拒绝,因为root账户的默认配置是只能localhost链接,可以将root修改为任意主机可链接,但是显然会有安全性的问题,
因此一般是新建立一个新的受限的user进行连接,用于数据库的读取写入等操作。