MySQL

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

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

MySQLは、人気のあるLAMP(Linux、Apache、MySQL、PHP/Python/Perl)スタックの一部として一般的にインストールされているオープンソースデータベース管理システムです。リレーショナルモデルを実装し、データを管理するためにSQL(Structured Query Language)を使用します。このチュートリアルでは、Ubuntu 20.04サーバーにMySQLをインストールする方法について説明します。

Read more
How To Create a Multi-Node MySQL Cluster on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Create a Multi-Node MySQL Cluster on Ubuntu 16.04

MySQL cluster is a software technology which provides high availability and throughput. In short, there is one or more management nodes which control the data nodes (where data is stored). After consulting with the management node, clients (MySQL clients, servers, or native APIs) connect directly to the data nodes.

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

How To Install and Secure phpMyAdmin on Ubuntu 16.04

While many users require access to a database management system like MySQL, not all users feel comfortable interacting with the MySQL prompt on a daily basis. In this guide, we’ll discuss how to install and secure phpMyAdmin, a web management interface for MySQL, on an Ubuntu 16.04 server.

Read more
Como Instalar o MySQL no Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Como Instalar o MySQL no Ubuntu 18.04

Não está usando o Ubuntu 18.04? Escolha uma versão diferente: Uma versão anterior desse tutorial foi escrita por Hazel Virdó MySQL é um sistema de gerenciamento de banco de dados…

Read more
How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04

A MySQL transaction is a group of logically related SQL commands that are executed in the database as a single unit. Transactions are used to enforce ACID (Atomicity, Consistency, Isolation, and Durability compliance in an application. This is a set of standards that govern the reliability of processing operations in a database. In this tutorial, you will use the PDO PHP Extension, which provides an interface for working with databases in PHP, to perform MySQL transactions.

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