Build a XAMPP environment on Ubuntu

Introduction

• I summarized how to build a XAMPP environment on Ubuntu. XAMPP is a package of free software required to execute web applications. Here, it is used as a DB server.

Operating environment

• Ubuntu 20.04 LTS
• XAMPP 7.4.8 (for Linux)

XAMPP installation

First, install XAMPP.

1. Access the following site. https://www.apachefriends.org/jp/index.html

2. Click XAMPP for Linux. ⇒ The XAMPP installer "xampp-linux-x64-7.4.8-0-installer.run" will be downloaded.

3. Launch the installer. (By default, it will be installed in / opt / lampp.)

   $ sudo ./xampp-linux-x64-7.4.8-0-installer.run
   

[sudo] ubuntu password: ---------------------------------------------------------------------------- Welcome to the XAMPP Setup Wizard.

----------------------------------------------------------------------------
Select the components you want to install; clear the components you do not want
to install. Click Next when you are ready to continue.

XAMPP Core Files: Y (Cannot be edited) ★ Press the "y" key.

XAMPP Developer Files [Y / n]: y ★ Press the "y" key.

Is the selection above correct? [Y / n]: y ★ Press the "y" key.

----------------------------------------------------------------------------
Installation Directory

XAMPP will be installed to /opt/lampp

Press [Enter] to continue: ★ Press the "Enter" key.

----------------------------------------------------------------------------
Setup is now ready to begin installing XAMPP on your computer.

Do you want to continue? [Y / n]: y ★ Press the "y" key.

----------------------------------------------------------------------------
Please wait while Setup installs XAMPP on your computer.

 Installing
 0% ______________ 50% ______________ 100%
 #########################################

----------------------------------------------------------------------------
Setup has finished installing XAMPP on your computer.
~~~

4. Make sure it is installed in / opt / lampp.

   $ ls /opt/lampp/
   README-wsrep  ctlscript.sh  info      manager-linux-x64.run  properties.ini
   README.md     docs          lampp     manual                 sbin
   RELEASENOTES  error         lib       modules                share
   THIRDPARTY    etc           lib64     mysql                  temp
   apache2       htdocs        libexec   pear                   uninstall
   bin           icons         licenses  php                    uninstall.dat
   build         img           logs      phpmyadmin             var
   cgi-bin       include       man       proftpd                xampp
   

5. Install the tools needed to run XAMPP.

   $ sudo apt-get install net-tools
   

phpMyAdmin settings

Next, configure phpMyAdmin settings.

1. Set it so that it can be accessed from other machines.

   $ sudo nano /opt/lampp/etc/extra/httpd-xampp.conf
   

【Change before】 <Directory "/opt/lampp/phpmyadmin"> AllowOverride AuthConfig Limit Require local ★ Before change ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var ~~~

~~~

[After change] <Directory "/opt/lampp/phpmyadmin"> AllowOverride AuthConfig Limit Require all granted ★ After change ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var ~~~

Start phpMyAdmin

Start phpMyAdmin.

1. If you have Apache, MySQL, or ProFTPD running, you need to stop it.

[Example] For Apache $ sudo systemctl stop apache2 ~~~

2. Start XAMPP. (If you get an error saying "already running", it may work after rebooting.)

   $ sudo /opt/lampp/lampp start
   

   $ sudo /opt/lampp/lampp restart
   

3. Start your browser and access the following URL to open "phpMyAdmin". http://{UbuntuのIPアドレス}/phpmyadmin/

4. Stop XAMPP.

   $ sudo /opt/lampp/lampp stop
   

Password setting

Set the password to access the database.

1. Open the User Accounts tab in phpMyAdmin.

2. Press the "Change Password" button in phpMyAdmin, change the password and press the "Run" button.

3. Open the phpMyAdmin configuration file (config.inc.php) and enter the password you set in the ★ section below.

   $ sudo nano /opt/lampp/phpmyadmin/config.inc.php
   

   /* Authentication type and info */
   $cfg['Servers'][$i]['auth_type'] = 'config';
   $cfg['Servers'][$i]['user'] = 'root';
   

$ cfg ['Servers'] [$ i] ['password'] ='****'; ★ Enter the password you set. cfg['Servers'][i]['extension'] = 'mysqli'; cfg['Servers'][i]['AllowNoPassword'] = true; $cfg['Lang'] = ''; ~~~

4. Make sure that the User Accounts tab in phpMyAdmin opens. (If the password cannot be set in config.inc.php, an error will occur.)

Database creation

Create a database.

1. Open the Import tab in phpMyAdmin.

2. Click the "Browse" button on the right side of the upload field, select the following SQL file, and click the "Execute" button to register the database of the user account. (Leave all the default settings.)

/ * Create sample database * / create database sample;

/ * Use sample database * / use sample;

/ * Create account table * / CREATE TABLE sample.account ( username CHAR(20) NOT NULL, password CHAR(20) NOT NULL, mailaddr CHAR(30) NOT NULL, PRIMARY KEY ( username ) );

/ * Register user account information in the account table * / INSERT INTO sample.account (username, password, mailaddr) VALUES ('Yamada','yamada','[email protected]'); INSERT INTO sample.account (username, password, mailaddr) VALUES ('jun','jun','[email protected]'); INSERT INTO sample.account (username, password, mailaddr) VALUES ('Aiko','aiko','[email protected]'); INSERT INTO sample.account (username, password, mailaddr) VALUES ('Michael', 'michael', '[email protected]'); ~~~

3. Click sample> account in the tree on the left side of phpMyAdmin. ⇒ You can confirm that the account table is registered in the sample database.

Database operations

This is an example of operating a database.

1. Open the "SQL" tab in phpMyAdmin, enter the SQL statement and press the "Execute" button.

2. The execution result is displayed.