Explore information related to install phpmyadmin ubuntu


Install phpMyAdmin with Nginx on Ubuntu 18.04 - Step by Step Process ?

This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment. 


How to Secure phpMyAdmin with Let's Encrypt SSL ?

Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.

1. First, add the Certbot repository with the following command:

$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471

2. Next, update the repository and install the Certbot client using the following command:

$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y

3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:

$ certbot --nginx -d phpmyadmin.domain.com

Read More



Install PHP on Ubuntu 20.04 - Running Apache Web Server

This article covers the PHP installation on Ubuntu 20.04 system.  Basically, popular Content Management platforms such as WordPress, Drupal, and Magento are based on PHP.


To Install PHP on Ubuntu 20.04:

1. Update your server.

$ apt-get update && apt-get upgrade

2. Install PHP on Ubuntu 20.04, just run the following command.

$ apt-get install php

3. To verify if PHP is installed, run the following command.

php -v


To Install PHP 7.4 modules (extensions):

Run the command below.

apt-get install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring php-xml libapache2-mod-php

To check all the PHP modules available in Ubuntu, run:

$ apt-cache search --names-only ^php


How to install PHP 8.0 on Ubuntu 20.04 or 18.04 ?

1. First, update your Ubuntu server:

$ apt-get update && apt-get upgrade

2. Add the PHP repository (by Ondřej Surý):

$ apt-get install software-properties-common
$ add-apt-repository ppa:ondrej/php

3. And finally, update your package list:

$ apt-get update

4. Install PHP 8.0 with the following command:

$ apt-get install php8.0

5. To check if PHP 8.0 is installed on your server, run the following command:

$ php -v

6. Install PHP 8.0 modules (extensions)

You may need additional packages and modules depending on your applications. The most commonly used modules can be installed with the following command:

$ apt-get install libapache2-mod-php8.0 php8.0-fpm libapache2-mod-fcgid php8.0-curl php8.0-dev php8.0-gd php8.0-mbstring php8.0-zip php8.0-mysql php8.0-xml


How to change the PHP version you're using ?

If you have multiple PHP versions installed on your Ubuntu server, you can change what version is the default one.

1. To set PHP 7.4 as the default, run:

$ update-alternatives --set php /usr/bin/php7.4

2. To set PHP 8.0 as the default, run:

$ update-alternatives --set php /usr/bin/php8.0

3. You can verify what version of PHP you’re using with the following command:

$ php -v

Read More



Install phpMyAdmin with Nginx on CentOS 7 - Step by Step Process ?

This article covers how to install phpMyAdmin with Nginx on CentOS 7 system. phpMyAdmin helps to handle the database administration of MySQL, MariaDB and Drizzle servers over the web. It basically provides the intuitive web interface and supports most of the MySQL features to create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement and to manage indexes on columns.


To install phpMyAdmin, run the following commands:

# yum install epel-release
# yum install phpmyadmin


To restart nginx, mariadb and php-fpm services, run the following commands:

# systemctl restart mariadb.service
# systemctl restart nginx.service
# systemctl restart php-fpm.service

Read More



Install phpMyAdmin with Apache on Ubuntu 18.04 - Step by Step Process ?

This article covers how to install phpMyAdmin with Apache on Ubuntu 18.04 system. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. 


Important php packages includes:

  • php-mbstring: A module for managing non-ASCII strings and convert strings to different encodings.
  • php-zip: This extension supports uploading .zip files to phpMyAdmin.
  • php-gd: Enables support for the GD Graphics Library.
  • php-json: Provides PHP with support for JSON serialization.
  • php-curl: Allows PHP to interact with different kinds of servers using different protocols.

Read More



Install LEMP Stack on Ubuntu 18.04 - Step by Step Process ?

This article covers how to Install a LEMP Stack on Ubuntu 20.04 LTS. LEMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. LEMP stands for Linux OS, with the Nginx (pronounced like "Engine-X") web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To install Nginx Web Server:

1.  Run the commands below to install Nginx.

$ sudo apt update
$ sudo apt install nginx

2. Allow traffic on port 80.

$ sudo ufw allow 'Nginx HTTP'

You can verify the change by running:

$ sudo ufw status

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com