Explore information related to install phpmyadmin ubuntu 20 04 nginx

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 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 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

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

This article covers how you can  seamlessly install phpMyAdmin on your Ubuntu Linux system.

Working with a database can sometimes be intimidating, but PhpMyAdmin can simplify tasks by providing a control panel to view or edit your MySQL or MariaDB database.

To Install phpMyAdmin on Ubuntu:
1. Update the apt package tool to ensure we are working with the latest and greatest.

$ apt update && upgrade

2. Install PhpMyAdmin and PHP extensions for managing non-ASCII string and necessary tools.

$ apt install phpmyadmin php-mbstring php-gettext

During this installation you’ll be asked for the web server selection, we will select Apache2 and select ENTER.
Here, you have the option for automatic setup or to create the database manually.
For us, we will do the automatic installation by pressing ENTER for yes.
3. At this setup, you'll be asked to set the PhpMyAdmin password.
Specifically for the PhpMyAdmin user, phpmyadmin,  you'll want to save this in a secure spot for later retrieval.
4. Enable PHP extension.

phpenmod mbstring

5. Restart the Apache service to recognize the changes made to the system.

# systemctl restart apache2

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