Linux

How To Install and Secure phpMyAdmin on Ubuntu 12.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure phpMyAdmin on Ubuntu 12.04

This tutorial covers installing phpMyAdmin on a LAMP stack. Additionally it includes the steps on how to secure it with the .htaccess file. phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities.

Read more
How To Install and Secure phpMyAdmin with Nginx on a CentOS 7 Server — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure phpMyAdmin with Nginx on a CentOS 7 Server

Administering relational databases from the command line can be a daunting proposition for many people. A project called phpMyAdmin aims to alleviate this issue by providing an easy to use web interface for MySQL. In this guide, we’ll discuss how to install and secure phpMyAdmin on top of a LEMP (Linux, Nginx, MariaDB, and PHP) stack on a CentOS 7 server.

Read more
How To Install and Use ClickHouse on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use ClickHouse on Ubuntu 20.04

ClickHouse is an open source, column-oriented analytics database created by Yandex for OLAP and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine. Then you’ll test ClickHouse by modeling and querying example website-visit data.

Read more
How To Install and Use Composer on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use Composer on Ubuntu 22.04

Composer is a popular dependency management tool for PHP, created mainly to facilitate installation and updates for project dependencies.It will check which other packages a specific project depends on and install them for you, using the appropriate versions according to the project requirements.

Read more
How To Install and Use PostgreSQL on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on CentOS 7

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
CHAT