# Aiuto db

**URL:** <https://www.ruby-forum.com/t/aiuto-db/146468>\
**Category:** IT\
**Created:** [August 21, 2008, 1:14pm UTC](https://www.ruby-forum.com/t/aiuto-db/146468 "2008-08-21T13:14:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![deshi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/57b2e6/32.png) [@deshi](https://www.ruby-forum.com/u/deshi)\
**Post date:** [August 21, 2008, 1:14pm UTC](https://www.ruby-forum.com/t/aiuto-db/146468/1 "2008-08-21T13:14:38Z")

</div>

Ciao a tutti avrei una domanda sui db in rails.

Ho installato il pacchetto autoinstallante per mac osx:  
[http://rubyosx.rubyforge.org/](http://rubyosx.rubyforge.org/)  
che di default utlizza sqlite.

Avrei bisogno però di settare a default MySql, (che ho già installato  
sul mio sistema)

Sapete consigliarmi la procedura più corretta per far vedere e gestire a  
Rails mySql ?

Grazie, e ciao a tutti.

---

<div class="post-metadata">

**Author:** ![deshi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/57b2e6/32.png) [@deshi](https://www.ruby-forum.com/u/deshi)\
**Post date:** [August 22, 2008, 12:06am UTC](https://www.ruby-forum.com/t/aiuto-db/146468/2 "2008-08-22T00:06:47Z")

</div>

Ciao,

On Thu, Aug 21, 2008 at 11:14 AM, Stefano P.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Rails mySql ?  
> Puoi creare un nuovo progetto rails definendo il db da usare con il  
> seguente comando:

#\> rails -d \<db\_name\>

l’help di rails riporta  
#\> rails -h

-d, --database=name Preconfigure for selected database (options:  
mysql/oracle  
/postgresql/sqlite2/sqlite3/frontbase).  
Default: sqlite3

Mentre se vuoi cambiare DB a un progetto gia` creato devi modificare il  
file:  
config/database.yml

io uso il seguente:

login: &login  
adapter: mysql  
username: db\_utente  
password: pw\_utente  
host: localhost.localdomain  
port: 3306  
encoding: utf8

development:  
\<\<: \*login  
database: db\_name\_dev

test:  
\<\<: \*login  
database: db\_name\_test

production:  
\<\<: \*login  
database: db\_name

Ciao,  
FEj

–  
FEj

“Go and spread the free software. Happy hacking!” - RMS