Skip to main content

Posts

Showing posts with the label Ubuntu

MySql Basics for Begineers

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL How to Install MySQL on Ubuntu and CentOS If you don't have MySQL installed on your system, you can quickly download it. Ubuntu: sudo apt-get install mysql-server Centos: sudo yum install mysql-server /etc/init.d/mysqld start How to Access the MySQL shell Once you have MySQL installed on your droplet, you can access the MySQL shell by typing the following command into terminal: mysql -u root -p After entering the root MySQL password into the prompt. Now you will be able to start building your MySQL database. Two points to keep in mind: All MySQL commands end with a semicolon; if the phrase does not end with a semicolon, the command will not execute. Also, although it is not required, MySQL commands are usually written in uppercase an...

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 18.04

Introduction A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the  L inux operating system, with the  A pache web server. The site data is stored in a  M ySQL database, and dynamic content is processed by  P HP. In this guide, we will install a LAMP stack on an Ubuntu 18.04 server. Prerequisites In order to complete this tutorial, you will need to have an Ubuntu 18.04 server with a non-root  sudo -enabled user account and a basic firewall. This can be configured using our initial server setup guide for Ubuntu 18.04. Step 1 — Installing Apache and Updating the Firewall The Apache web server is among the most popular web servers in the world. It's well-documented and has been in wide use for much of the history of the web, which makes it a great default choice for hosting a website. Install Apach...