1.Linux下MySQL的安装
引用
sudo apt-get install mysql-server libmysql-ruby
查看版本号确定是否安装完成。
可选安装Ruby语言数据库通用接口包及其MySQL接口包:
引用
apt-get install libdbi-ruby1.8 libdbi-ruby libdbd-mysql-ruby1.8 libdbd-mysql-ruby
检查安装结果:
irb(main):001:0> require 'dbi'
=> true
irb(main):002:0> exit
安装MySQL接口工具包
引用
sudo apt-get install libmysqlclient15-dev zlib1g-dev
sudo apt-get install libdbm-ruby1.8 libfcgi-ruby1.8 libfcgi0c2 libgdbm-ruby1.8 libopenssl-ruby1.8 libruby1.8-dbg
安装MySQL API接口包
引用
sudo gem install mysql -r
检查安装结果:
irb(main):001:0> require 'mysql'
=> true
irb(main):002:0> require 'rubygems'
=> true
irb(main):004:0> require_gem 'mysql'
=> true
irb(main):005:0> exit
2.设置UTF8编码
(1)确定mysql数据库编码是utf8
(2)database.yml里面增加encoding: utf8
(3)确定编辑器的保存文件格式为:UTF-8,保证rhtml文件编码是UTF-8
2,3条很好解决,MySQL编码的问题解决如下:
在linux下修改3个my.cnf的1个/etc/mysql/my.cnf文件
找到客户端配置[client] 在下面添加
default-character-set=utf8 默认字符集为utf8
在找到[mysqld] 添加
default-character-set=utf8 默认字符集为utf8
init_connect='SET NAMES utf8' (设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行)
修改好后,重新启动mysql 即可,查询一下show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
这样就不用每次连接 都使用 --default-character-set=utf8 了
3.安装MySQL前端
PHP下有phpmyadmin,Rails下也有railsmyadmin。安装方法见
http://code.google.com/p/railsmyadmin/
首先在应用中安装railsmyadmin
引用
.script/plugin install http://railsmyadmin.googlecode.com/svn/trunk/my_admin/
插件安装好后,生成RailsMyAdmin文件(这会把插件文件夹拷进应用文件夹)
引用
.script/generate my_admin
将下列代码加入environment.rb文件的底部,重启应用
## MY ADMIN CONFIG
require 'my_admin/my_admin_tool'
# If you only want certain models to be available to RailsMyAdmin,
# set :all_models to false and specify the desired models in MY_ADMIN_MODELS
MY_ADMIN_GLOBALS = {:all_models => true, :confirm_destroy => false}
# Uncomment the following line if you set :all_models to false above.
#MY_ADMIN_MODELS = [User, Content]
# Replace [User, Content] with your desired array of model classes that
# RailsMyAdmin should be restricted to.
# MY_ADMIN_AUTH must define a Proc object that takes as a paramater
# an ApplicationController instance variable (c - in the example below).
# If you have a method defined in your ApplicationController,
# 'admin_logged_in?' for example, the following sample code will
# authenticate against that method and only allow visitors to
# view RailsMyAdmin if the 'admin_logged_in?' method returns true.
MY_ADMIN_AUTH = Proc.new { |c| c.send('admin_logged_in?') }
使用方法如下:
http://localhost:3000/my_admin/main
命令列表:获得一个其他RailsMyAdmin的rake任务列表
引用
rake -T my_admin
分享到:
相关推荐
支持rails2.0以上版本的配置说明,文档从我自己的博客中整理出来,不愿意用资源分的朋友可以去我的博客看: http://wudihamagong.spaces.live.com/ 或者 http://blog.csdn.net/abcdefg0 ^_^
NULL 博文链接:https://zyn-zyn.iteye.com/blog/1186887
rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails 2.3.2离线安装rails ...
Ruby for Rails 英文原版, pdf格式 <br>本书是一部专门为Rails实践而写的经典Ruby著作,由四部分组成,共17章。第一部分讲述Ruby和Rails的编程环境。第二部分和第三部分与 Rails紧密联系,着重对Ruby这门语言...
Bootstrap 3 和 Rails 4(样例用的是Ruby 2.1.1,Rails 4.1.4) Table of Contents Preface 1 Chapter 1: Introducing Web Application Development in Rails 7 Why Bootstrap with Rails? 8 Setting up a Todo ...
Ruby 的基本知识,...安装 ruby ,rails...mysql 数据库...用 rails 实现的是一个简单的网上书籍管理程序 ...
本文简单介绍了Ruby On Rails的安装步骤以及MySQL数据库的配置方法,并介绍了几个官方阅读资源。
1.安装gem,进入gem文件夹,里面有个setup文件,直接双击就行了。 2.进入rails目录使用gem命令安装(这一步必须要上...3.复制libmySQL.dll到ruby的安装目录的bin文件夹下,然后使用gem安装mysql-2.7.3-x86-mswin32.gem.
ruby1.8.6 + rails2.0.2 + radrails0.7.2 + mysql 安装配置 详细说明
Packt.Publishing.Aptana.Radrails.An.Ide.for.Rails.Development.May.2008.pdf
[Ruby_on_Rails][中文][Rails_5.x]__03-2_._安裝不同版本的Rails與產生Rails_5.x版
Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 Ubuntu系统ruby on rails安装 ...
For a .NET developer, learning Rails is as much about the cultural and philosophical shifts in thinking as it is about the technical learning curve. In this book, we hope to break down some of these ...
rails for zombies 课件
Ubuntu 11.04安装Ruby on rails 连接MySQL数据库.pdf
for rails 安装rails必须资源.for liliu
Rbuy for Rails源代码
这是Agile Web Development with Rails for Rails 3.2, 为3.2的版本修改过的
[Ruby_on_Rails][資料庫]_03._[Windows]_MySQL安裝
rails 配置文档 ror ruby on rails