Pages

Showing posts with label MariaDB. Show all posts
Showing posts with label MariaDB. Show all posts

Change PHPMyAdmin port number from 80 to another


Add a new port number to Apache

Port 80 is the default number of PHPMyAdmin. On certain occasions, we need to change the port number to another. Here are the steps to accommodate PHPMyAdmin to a new port number. 

Open ports.conf file, 

sudo mousepad /etc/apache2/ports.conf

Add a new port number (e.g. 8001). Add the following line, save and close the file.

Listen 8001

Open a new Apache virtual host. Open the following file,

sudo mousepad /etc/apache2/sites-available/phpmyadmin.conf

Copy the following piece of code into the file,

<VirtualHost *:8001>
        ServerName localhost
        <Directory /usr/share/phpmyadmin>
                AllowOverride None
                Require all granted
        </Directory>
        DocumentRoot /usr/share/phpmyadmin
        Include /etc/phpmyadmin/apache.conf
        ErrorLog ${APACHE_LOG_DIR}/phpmyadmin.error.log
        CustomLog ${APACHE_LOG_DIR}/phpmyadmin.access.log combined
</VirtualHost>

Save and close the file. Apply the following commands one by one.

sudo a2disconf phpmyadmin
sudo a2ensite phpmyadmin
sudo systemctl restart apache2.service
sudo service apache2 restart

Open PHPMyAdmin in the browser, localhost:8001

Reference

https://askubuntu.com/questions/896988/change-phpmyadmin-port-from-80-to-another-number

Installation of LAMP stack on Debian/Ubuntu

Popular enterprises applications run on the LAMP stack; Linux, Apache, MySQL/MariaDB, and PHP. WordPress, Drupal, Moodle, and similar application software run on LAMP. Installation of a LAMP stack on Linux-based operating systems like Debian/Ubuntu is comparatively easier than before.

Install the latest stable version of Debian/Ubuntu first. I prefer to use lightweight Ubuntu flavour Xubuntu for this purpose. Here are the steps and commands to install LAMP infrastructure.

Update the Debian/Ubuntu
sudo apt update
sudo apt upgrade


Install MariaDB on Ubuntu 18.04 LTS

Visit the following link and choose the desired version of MariaDB,

https://downloads.mariadb.org/

Following commands will add repository and install MariaDB 10.3,

sudo apt-get install software-properties-common

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirrors.tuna.tsinghua.edu.cn/mariadb/repo/10.3/ubuntu bionic main'

sudo apt update

sudo apt install mariadb-server