XAMPP/LAMP installation in ubuntu

by SRIKRUSHNA PAL · Published November 17, 2018 · Updated December 12, 2018

Note : LAMPP is the Linux specific version of XAMPP.

Download LAMPP-Server using this command
$sudo apt-get install lamp-server^
Goto https://www.apachefriends.org/download.html and download the version of LAMPP software that you want for Linux (Ubuntu).
Open your Terminal and locate the file (by default it downloads into the Downloads folder)
cd Downloads
Execute this command
sudo chmod +x xampp-linux-x64-7.1.7-0-installer.run
Note : The version of XAMPP you’ll download might be different, so change the version in this command accordingly.
You’ll be asked for your system’s password
Now go into SuperUser mode
sudo su
Run the installer, but don’t close the Terminal.
./xampp-linux-x64-7.1.7-0-installer.run
Note: Again change the version for executing this command.
A dialog box will open, if you get an error, ignore it. In the dialog box, click next(for each step) and move through the process of installation. Once XAMPP is installed, click finish.
Go back to your Terminal and change the directory
cd /opt/lampp
To set a password, type
./lampp security
Press y(Enter) and enter a new password and re-enter this password again to confirm
Start XAMPP
./xampp start
Type exit(Enter) to exit the SuperUser
To start LAMPP, execute this command
sudo /opt/lampp/lampp start
To stop LAMPP, execute this command
sudo /opt/lampp/lampp stop

Go to your Terminal and change the directory


cd /opt/lampp
./xampp start

Another way:
sudo /opt/lampp/lampp start


Start your XAMPP/LAMPP
sudo /opt/lampp/bin/mysql


create database yourDatabaseName;
use yourDatabaseName;
source pathToYourSQLFile;    //enter full path of your SQL file

show tables;