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

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.

×
2 answers

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.

by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.
Submit an Answer