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
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!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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
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:
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 :
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.