MySQL

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 Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7

In this guide, we’ll get a LEMP stack installed on an CentOS 7 server. A LEMP software stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the ENginx web server (which replaces the Apache component of a LAMP stack). The site data is stored in a MySQL database (using MariaDB), and dynamic content is processed by PHP.

Read more
Ubuntu 20.04にMariaDBをインストールする方法 — step-by-step Linux tutorial on Progressive Robot

Ubuntu 20.04にMariaDBをインストールする方法

MariaDBは、人気の高いLAMP(Linux、Apache、MySQL、PHP/Python/Perl)スタックのMySQL部分の代替として使用されているオープンソースデータベース管理システムです。MySQLの代わりになることが意図されています。このチュートリアルでは、Ubuntu 20.04サーバーにMariaDBをインストールして、それが作動し安全に初期設定されていることを確認する方法を説明します。

Read more
How To Install MySQL on Rocky Linux 9 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on Rocky Linux 9

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL on a Rocky Linux 9 server.

Read more
Установка MySQL в Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

Установка MySQL в Ubuntu 20.04

Предыдущая версия настоящего обучающего модуля составлена Хейзел Вирдо MySQL — это система управления базами данных с открытым исходным кодом, которая, как правило, устанавливается в составе…

Read more
How To Install WordPress with a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install WordPress with a Managed Database on Ubuntu 18.04

WordPress is the most popular CMS (content management system) on the internet. It allows you to easily set up flexible blogs and websites on top of a MySQL backend with PHP processing. In this guide, we’ll focus on getting a WordPress instance set up on a managed MySQL database on an Ubuntu 18.04 server.

Read more
How To Manage and Use MySQL Database Triggers on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Manage and Use MySQL Database Triggers on Ubuntu 18.04

In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and is destroyed once a table is dropped. You can specify a trigger action time and set whether it will be activated before or after the defined database event. In this tutorial, you’ll create, use, and delete different types of triggers on your MySQL database.

Read more
CHAT