how to connect to existing db?

rubyonrails-talk
1

this is what i'm putting into putty to create the db.

]$ mysqladmin create bean_development mysqladmin: connect to server at 'localhost' failed

I'm using ruby through a shared server from hostmonster. i have a db &user set up through the cpanel system already.

how do i connect to my existing db?

2

Hi

this is what i'm putting into putty to create the db.

]$ mysqladmin create bean_development mysqladmin: connect to server at 'localhost' failed

You mean, you wanted to connect to database from shell using:

$ mysql -p -u username bean_development

?

where username is your user name and you'll be asked for password. This is provided that database is on the same host that you log into via Putty. If database is on different host then you'll have to specify remote host with "-h" parameter.

I'm using ruby through a shared server from hostmonster. i have a db &user set up through the cpanel system already.

how do i connect to my existing db?

Now ,if in Rails, you have to edit your config/database.yml file to provide database access details.

3

Thing is... I have sqlite3-ruby installed. This is what my db config file shows:

# Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test:   adapter: sqlite3   database: db/test.sqlite3   timeout: 5000

there is also a sqlite3 db for production and development. Is this it? Do I need to be at all concerned about my external mySQL db? It's not necessary for me to use the external DB, I just thought it might simplify things.

Seeing this is the case, should I go any further or leave this config alone?

If it is left alone.... where can I view the db?

I'm a newbie, so pardon my ignorance. I am learning more as I go along!

Hubert Łępicki wrote: