Jump to content

How would I create a database through SSH?

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
5 replies to this topic

#1
blkobswg

blkobswg

    Newbie

  • Members
  • Pip
  • 3 posts
I am building a website on a server that I do not have direct access to and it does not have a Server CP. I was told by my web programming professor that I would need to ssh into the server and then add the database via command line.

I have no clue what programs I need on my side, or what programs need to be on my server.

If you could give me step by step instructions on how to do it that would be great :)

#2
Guest_Jordan_*

Guest_Jordan_*
  • Guests
Are you on linux? What database soft, mysql? If so, ssh in and execute mysql -u UserNameHere -p

it will ask for your password, enter it. Then you can use SQL to create your dbs.
Posted via CodeCall Mobile

#3
blkobswg

blkobswg

    Newbie

  • Members
  • Pip
  • 3 posts
How do I SSH in?

I believe that it is mysql...

#4
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,298 posts
you need a ssh client like putty to connect to your server.

but all of this should your host be able to answer easiest.
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall

#5
blkobswg

blkobswg

    Newbie

  • Members
  • Pip
  • 3 posts
okay, I got that far. I tried to log in with my ftp info that I was given but I guess that that is not the info that I need... :/

I do not have direct contact with the server owner. I have to go through a friend to get to the server owner. So what do I need to ask him for?

#6
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,298 posts
Easiest is to ask for a database set up directly and login info for it directly so they do it for you.
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall