Query on db with mysql

rubyonrails-talk
1

Hi all,

I have a host that allows ssh access but only on the main account. I was just wondering can you setup the db without using the command line e.g db:migrate generate etc as on my main account its fine but if i setup other sites i will have to pay $10/£6 to activate ssh.

Thanks

2

Hi all,

I have a host that allows ssh access but only on the main account. I was just wondering can you setup the db without using the command line e.g db:migrate generate etc as on my main account its fine but if i setup other sites i will have to pay $10/£6 to activate ssh.

I think it will be very difficult to administer without command line access. As well as db setup you will likely need to do bundle install and so on. Possibly a change of provider is in order.

Colin

3

Quoting Paul Na <lists@ruby-forum.com>:

Hi all,

I have a host that allows ssh access but only on the main account. I was just wondering can you setup the db without using the command line e.g db:migrate generate etc as on my main account its fine but if i setup other sites i will have to pay $10/£6 to activate ssh.

Cannot you ssh into the main account and then change user to the other account? My Amazon cloud account is like this. Only one normal user account is allowed to ssh in. I then change to the root and Web server accounts as needed.

HTH,   Jeffrey

4

Hi,

Sorry for the late reply i have been busy. I have got a vps now but Jeffrey you are right i totally forgot that but its to late now as i have cancelled the account.

Thanks anyway

Paul

5

Excellent advice not only for getting around expensive restrictions, but for security as well. My usual procedure is to set up an account that is highly restricted, but can accept ssh sessions, with username and password that are long and hard to guess (but reasonably easy to remember and type -- a la "correct horse battery staple"). Once there, I can su to whatever other accounts I need to use. (Still with reasonably strong names and passwords though!)

-Dave