Query on db with mysql

11155 · March 13, 2020, 11:40pm

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

Colin_Law1 · March 14, 2020, 1:54am

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

Jeffrey · March 14, 2020, 1:54am

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

11155 · March 14, 2020, 1:54am

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

Dave_Aronson2 · March 14, 2020, 1:54am

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