APACHE AND MYSQL

-

 

APACHE AND MYSQL

 

Apache2 Web Server

 

Apache is the most commonly used Web server on Linux systems. Web servers are used to serve Web pages requested by the client computers.

 

Installation

 

sudo apt install apache2

 

Restart Apache

 

sudo service apache2 restart

 

Stop Apache

 

sudo service apache2 stop

 

Start Apache

 

sudo service apache2 start

 

Default document folder of Apache located in

 /var/www/ MySQL/MariaDB

 

MySQL/MariaDB is a fast, multi-threaded, multi-user, and robust SQL database server. It is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

 

Installation

 

sudo apt-get install mysql-server sudo apt-get install mariadb-server

 

Restart

 

sudo service mysql restart

 

Stop

 

sudo service mysql stop

 

Access the MySQL shell

 

mysql -uroot -p

 

Enter MySQL Root password.

Create and Delete a MySQL Database

Show Databases

 

show databases;

 

Create Database

 

create database tom;

 

Open Database

 

use tom;

 

show tables;

 

Delete Database

 

drop database tom;

 

REFERENCES

https://help.ubuntu.com/

Comments

Post a Comment

Popular posts from this blog

BASIC LINUX COMMANDS

-
Image
  Display information about the Operating  System hostnamectl   Display information about the CPU architecture lscpu   Listing files and directories   ls   Detailed listing   ls -l   Lots of details about the contents of your directory   The * wildcard   ls d*   This will list all files in the current directory starting with d   Making Directories   mkdir tom   Changing to a different directory   cd tom   Change to the parent directory   cd ..   will take you one directory up the hierarchy. Command Meaning ls List files and directories ls -a List all files and directories mkdir Make directory cd directory Change directory cd Change to the home directory cd ~ Change to the home directory...
continue reading »

Header on DSpace JSPUI interface

-
Image
  Customised header on DSpace JSPUI interface Prepare a header image and place in Dspace folder e.g.  cp header.png /opt/tomcat/webapps/jspui/image Hide Dspace brand heading Open header-default.jsp file using Terminal. Apply following commands, sudo su gedit  /opt/tomcat /webapps/jspui/layout/header-default.jsp Find following lines  </header> <main id="content" role="main"> <div class="container banner">     <div class="row">         <div class="col-md-9 brand">             <h1><fmt:message key="jsp.layout.header-default.brand.heading" /></h1>             <fmt:message key="jsp.layout.header-default.brand.description" />         </div>         <div class="col-md-3"><img clas...
continue reading »

Install LibreOffice

-
Image
  How to Install LibreOffice    The default LibreOffice office suite reached the new major 6.2 released a few days ago. Here’s how you can install it in Ubuntu 18.04, Ubuntu 16.04, Linux Mint 18/19, and derivatives.According to  Libreoffice 6.2 release  note, the new release brings new icon themes and app icons, better KDE integration, reworked image handling, improvements to Excel 2003 XML import, continued GTK3/GNOME improvements, and more. How to Install LibreOffice 6.2 via Snap in Ubuntu: While LibreOffice PPA is not ready for the new release at the moment, you can install the snap package in Ubuntu 18.04 and/or Ubuntu 16.04 easily via following steps.Snap is containerized software package, designed to work securely within most Linux desktop. It bundles all its dependencies and auto-updates itself. To install LibreOffice 6.2 snap, simply open Ubuntu Software, search for and install the first ‘libreoffice’ package from Snappy store. Or open terminal (Ctrl+Alt...
continue reading »