Question

Website from scratch?

Hello, hope you all are well

So I have a domain registered with go daddy and I have created a droplet with the LAMP installation on droplet through the Marketplace, and I can easily connect using terminal ssh to droplet and can navgate through files.

I am new in terms of computers and all I can do in command-line is navigate around make/delete/move directories, I’d like to setup and understand mySQL database and how to setup and use phpmyadmin as well, as I am an aspiring computer scientist. I am trying to create websites in order to teach my selfs how to handle manage and query database and in order for the website itself for now I will be using a template from internet until I finish my own HTML, CSS and Js project.

If anybody can provide suitable links to guide and help resolve my queries

Much appreciated


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

This is awesome thank for sharing this article tutorial, it will be so useful a lot for me

Thanks for Sharing.

Hi @ahmerhh,

If you’ve used the MarketPlace to install a LAMP droplet, this would mean you already have MySQL installed. You’ll just need to start using it. To use it from your command line, you need to type in

mysql

while you are shed to your droplet.

If you want to use MySQL as a GUI, you’ll need to install phpMyAdmin. You can use the following tutorial to do so:

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

Now, next to the second question. In order to create a website, you’ll need to create an Apache conf file and then point your domain to your droplet. Let’s start with creating a config file in Apache for your domain. You can use the following article :

https://digitalocean.com/community/tutorials/how-to-set-up-apache-virtual-hosts-on-ubuntu-18-04

The next one would be to make sure you point your DNS to your droplet. If you need articles on that, let me know, please.