Super new, help would be lovely!

July 15, 2016 635 views
Applications Quickstart Linux Basics DNS

Alright so I'll start with this is my first time ever using a "non-traditional" "DIY" kind of host, I've always used pre-plans on and cpanel for anything related to websites, I've been searching through the knowledge base on what I can't and can do. Basically what I need right now is:

  • phpmyadmin / sql(sql is semi-installed atm)
  • Function webserver (which is currently in progress..ish)
  • apache
  • 5.6 php with basic settings on it

My current plan is the $20 plan, hosted in NYC1 with Ubuntu 14.04 installed.

I was wondering if it would be more worth setting up a cpanel that's free? Or is it better to learn this myself currently?

I'm not necessarily asking for you to do these things for me, but to give me a few helpful links and maybe some I missed in the knowledge base, any help would be really appreciated!

1 Answer

Welcome! :)

I would recommend setting everything up yourself and then deciding if you want to continue that way or wiping the Droplet and installing a control panel instead. While it might seem intimidating at first, everything should go smoothly as long as you follow the tutorials slowly and accurately and make sure that you understand everything that you're doing before moving on.

First, after creating your Droplet, you will want to set up the essentials and make sure that it's secured:

Then, install Apache (the webserver), PHP, and MySQL:

As for phpMyAdmin, while I would recommend against installing phpMyAdmin or any online/hosted MySQL client on your Droplet for security reasons, you can follow this tutorial to install it (it should work fine on 14.04):

A better alternative would be using an SSH tunnel to connect to port 3306 (MySQL) securely on your Droplet, and then using a local desktop client in order to manage your MySQL server:

The IMAP Tunnel example should fit your usecase, as long as you replace port 110 with 3306 :)

Good luck, and let us know how it goes!

by Etel Sverdlov
This tutorial covers installing phpMyAdmin on a LAMP stack. Additionally it includes the steps on how to secure it with the .htaccess file. phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities.
  • Hey first of all I'd like to say thanks this really helped currently I am using the BitVise SSH client, and I installed apache2, phpmyadmin, but I dont know where to go from there, is there a way I can access the /www/ folder in things like filezilla? where would I go about doing things like that?

    • Yes. You can use FileZilla to connect to your Droplet via SFTP to securely manage your files. Use the same username and password that you created while following the Initial Server Setup tutorial with the port set to 22. You should then be able to browse to /var/www/html/ and see your files.

      After a quick Google search, I can see that BitVise also supports SFTP file transfers, so you can use that too if you prefer. The same SSH credentials should work, again.

Have another answer? Share your knowledge.