Rails and mysql

Rails
1

Hello:

I have been used to mysql.But how to install it with rails 2.1? I can
find many instructions for sqlite with rais2.1 except mysql.

2

To create a rails app that uses mysql instead of the default of sqlite
you can run the command “rails myappsname -d mysql”

(this assumes you have mysql installed)

Best.
Mike

3

Michael B. wrote:

To create a rails app that uses mysql instead of the default of sqlite
you can run the command “rails myappsname -d mysql”

(this assumes you have mysql installed)

Best.
Mike

thank you!But i do not know how to install the mysql.just download it
and install it or need some gem?

4

mysql should be downloaded and installed
There is a mysql driver that should be installed as well.

On Jun 20, 10:25 am, Guo Y. [email protected]

5

Driver?

Install MySQL separate using either the installer for Windows or rpm/
source if you are on a unix system. Make sure mysql is working and is
listening to a port that you can connect to. (like 3306)

Either create a new rails project with -d mysql or edit your confg/
database.yml to look like this:

development:
adapter: mysql
encoding: utf8
database: database_devel
username: root
password:
port: 3306

By default there is a ruby driver that is installed WITH rails so
there is no need to install anything to get MySQL working with rails.
There is a NATIVE gem that you can install to get better performance
for MySQL and this is recommended for production … Something like
this:

gem install mysql – --with-mysql-config (if mysql is in your path)

6

Have you been able to resolve the problem?

On Jun 20, 6:04 pm, Guo Y. [email protected]

7

heimdull wrote:

Driver?

Install MySQL separate using either the installer for Windows or rpm/
source if you are on a unix system. Make sure mysql is working and is
listening to a port that you can connect to. (like 3306)

Either create a new rails project with -d mysql or edit your confg/
database.yml to look like this:

development:
adapter: mysql
encoding: utf8
database: database_devel
username: root
password:
port: 3306

By default there is a ruby driver that is installed WITH rails so
there is no need to install anything to get MySQL working with rails.
There is a NATIVE gem that you can install to get better performance
for MySQL and this is recommended for production … Something like
this:

gem install mysql – --with-mysql-config (if mysql is in your path)

Thank you!I should be able to resolve it.